SQL CREATE Table

Table:

A table in SQL is a set of data which is systematically displayed in rows and columns.

The CREATE TABLE Statement is used to create a new table.

Syntax:

CREATE TABLE tableName (columnName1 datatype, columnName2 datatype, ...   columnNameN datatype);

Example:

CREATE TABLE EMPLOYEE (   EMP_ID INT NOT NULL,   NAME VARCHAR (20) NOT NULL,   AGE INT NOT NULL,   SALARY INT NOT NULL,   PRIMARY KEY (EMP_ID)   );

Output:

Table created.

Note: We can use DESC command to see the created table.

DESC EMPLOYEE;

Table Column Data Type Length Precision Scale Primary Key Nullable Default Comment EMPLOYEE EMP_ID Number - - 0 1 - - NAME Varchar 20 - 0 - - - AGE Number - - 0 - - - SALARY Number - - 0 - - -