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

Create Table Example :

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.

CustomerID   INT              NOT NULL,
CustomerName VARCHAR (20)     NOT NULL,
Age  INT              NOT NULL,
Address  CHAR (25) ,
CustomerSalary   DECIMAL (18, 2),       

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

CustomerID CustomerName Age Address CustomerSalary

Visit :


* You must be logged in to add comment.