SQL Create Table

The SQL Create Table is used to create new table in the database.

Create Table Syntax :

The syntax of the Create Table is −
In creating a basic table involves, define the naming of the table (table-name) and its columns (column 1, column 2 ..... column) and the datatype of each column (column 1 datatype ...... column 2 data Type).

CREATE TABLE table-name (
column1 datatype,
column2 datatype,
column3 datatype,
.
.
.
columnN datatype
); 

The following code block is an example, which creates a table name Customer that contains the following column names (CustomerID, CustomerName, Age, Address, Customer List), where CustomerID is a primary key and not NULL.

CREATE TABLE Customer(
CustomerID   INT              NOT NULL,
CustomerName VARCHAR (20)     NOT NULL,
Age  INT              NOT NULL,
Address  CHAR (25) ,
CustomerSalary   DECIMAL (18, 2),       
PRIMARY KEY (ID)
);

The empty "Customer" table will now look like this:

Visit :

Discussion