8
Reply

What is syntax for create new Table in database?

Sandeep Kumar

Sandeep Kumar

10y
1.3k
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))