8
Reply

What is syntax for create new Table in database?

Sandeep Kumar

Sandeep Kumar

9y
1.2k
0
Reply

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