CREATE TABLE COMMAND

The CREATE TABLE statement is used to create a table in a database.

Syntax:

Create table <Table name>

(

Column 1,

Column 2,

.,

.,

.,

Column N

)

Note: The data type specifies what type of data the column can hold.

Example:

create table Sample_Table

(

ID int,

Name varchar(20),

Gender char(1)

)