CREATE TABLE statement is used to create a table in a database.
SYNTAX
CREATE TABLE table_name( column1 datatype, column2 datatype, ..... ..... columnN datatype, PRIMARY KEY(column_name ) );
EXAMPLE
CREATE TABLE STUDENT ( ID INT NOT NULL, NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL, ADDRESS CHAR (25) , PRIMARY KEY (ID) ); Table created.
Explaination
STUDENT is name of the table having 4 columns and 1 constraints
Column 1 : ID of INTEGER data type and having Primary Key Constraint
Column 2 : NAME of VARCHAR data type
Column 3 : AGE of INTEGER data type
Column 4: ADDRESS of CHARACTER data type