SQL Create Table

create table query in sql creates table in database.


SYNTAX :
CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
....
)

1. table_name is the name of table.
2.column1,column2,... -> are the name of the columns.
3.datatype -> is the datatype of the column.
4.we can also define Integrity Constraints

Integrity Constraints like primary key,uniqe key,not null etc
it can be defined for the columns while creating the table.



Online Execute/Compile