What is syntax for create new Table in database?

Sandeep Kumar

619

create table tb ()

create table tb ()

create table tb ()

create table tb ()

create table tb ()

create table tb ()

create table tb ()

Create Table tbl_User ( Id Int Not null Identity(1,1) Primary key , UserName varchar(50) )

create Table TableName ( Col1 DataType )

CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), column_name3 data_type(size), .... );

Create Table table_name (// all columns with data type will goes here )

create Table (

[Size]);

eaxamplecreate table Emp(id int identity(1,1), name varchar(50),sal int)

Syntax for creating new table is: create table table name(column name data type(size)) Ex: create table EmployeeDetails(Eid int,EName varchar(20))