Create/Alter/Drop table

Create Table:
                          CREATE TABLE Employee_Mst

                          (

                           Id int , 

                          varFirstName varchar(30), 

                          varLastName varchar(30)

                          );

• if you want to Add  Primary key in Employee_Mst Table use Alter Function:
• -Ex: Alter table Employee_Mst ADD  PRIMARY KEY (Id);

• if you want to Add Column in Employee_Mst also use Alter Function:
• -Ex: Alter table Employee_Mst ADD varAddress varchar(255)

• if you want to Drop Column in Employee_Mst also use Alter Function:
• -Ex: Alter table Employee_Mst Drop varAddress

• if you want to Drop table  Employee_Mst Drop Function use:
• -Ex: Drop table Employee_Mst