SQL Create Table In this tutorial we will learn how to create a table in Database using sql query, you can use mysql or SQL Server to create table. Create Table Syntax CREATE TABLE table_name ( column1_name data_type constraints, column2_name data_type constraints, .... ); dgdgfdg CREATE TABLE tblemplyee ( Id bigint identity (1,1) not null, name nvarchar(200) null, password_ nvarchar(100)null, email_ nvarchar(50) null, profile_pic nvarchar(max) null, date_time nvarchar(50) null ); upon the given tblemployee is table name you can type anything which you want but in Development time we need to understand table so we can use short name of Table to tbl. upon the given table code, Id is Column Name, bigint is datatype of column, identity (1,1) is autoincrement,not null mean that this column not goes in blank. Create Table With Primary Key CREATE TABLE tblemplyee ( Id bigint identity (1,1) not null, name nvarchar(200) null, password_ nvarchar(100)null, email_ nvarchar(50) null, profile_pic nvarchar(max) null, date_time nvarchar(50) null PRIMARY KEY ( Id ASC ) );