(function openLouie() { let louie = document.getElementById("Dropdown-Toggle-14"); louie.classList = "host-toggle w-dropdown-toggle w--open"; console.log(louie); })();
Create Table


Parameter      Details 

tableName                 The name of the table 

columns                                  Contains an 'enumeration' of all the columns that the table have.

To create a new table in the database, the create table statement is used. A table definition consists of a list of columns, their types, and any integrity constraints. 

Create Table From Select

You may want to create a duplicate of the table you are using

To modify the data before passing it to the new table, you can use any of the other features of a SELECT statement. The columns of the new table will be created in reference to the selected rows.

Create a new Table 

A basic Students table, containing an ID, and the student’s first and last name along with their student number can be created using:

This example is specific to Transact-SQL 

CREATE TABLE command is used to create a new table in the database, followed by the table name, Students.

This is then followed by the list of column names and their properties, such as the ID

Values and their Meanings 

Id: the name of the column

Int: is the type of data.

identity(1,1): the column is going to have auto generated values starting at 1 and increases by one for each new row. 

Primary key: means that all values in this column are going to have different values 

not null: means that column will not have null values

Simplicity Meets High Performance

Free edition subscription
Keep your work
No credit card required to try