SQL Create Table statement

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
)
);