TABLES in SQL Server

Creating SQL Server Tables Syntax

 CREATE TABLE Persons  
  (  
  PersonID int,  
  LastName varchar(255),  
  FirstName varchar(255),  
  Address varchar(255),  
  City varchar(255)  
  );   

Alter SQL Server Table syntax (ADD Column)

 ALTER TABLE table_name ADD column_name datatype  

Alter SQL Server Table syntax (DROP Column)

 ALTER TABLE table_name DROP column_name datatype