You can use below syntax to create table in SQL .

Create Table Employee

  (

  Column1 DataType,

   Column2 DataType,

   Column3 DataType

   ....

  )

Example :

Create Table Employee

  (

  Id Int Identity constraint Pk_Employee_Id Primary Key(Id),

   Name Varchar(100),

   EntryDate DateTime Constraint Df_Employee_EntryDate Default(GetDate()),

   EntryBy Int,

  ModifiedDate DateTime,

   ModifiedBy int

  )