RealWorldDevelopers
9/19/2016 - 11:43 PM

Add or Drop Column in a SQL Table

Add or Drop Column in a SQL Table

AddDropColumn.sql
content_copyfile_download
-- Add
ALTER    TABLE   [NameOfDatabase].[dbo].[NameOfTable]   ADD   NameOfColumn datatype  

--Delete
ALTER    TABLE   [NameOfDatabase].[dbo].[NameOfTable]   DROP    COLUMN   NameOfColumn