====== Microsoft - Microsoft SQL Server - SQL - Columns - Add Columns ======

<code sql>
ALTER TABLE dbo.dcsAAH_and_Enterprise_Reps_FullConstruct_W01_UK
add S NVARCHAR(30) null;
</code>

<code sql>
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add Display_41_License_Number Nvarchar(50) Null;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add Valid_From_Cd_41_Display Nvarchar(50) Null;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add Valid_To_Cd_41_Display Nvarchar(50) Null;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add Display_42_License_Number Nvarchar(50) Null;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add Valid_From_Cd_42_Display Nvarchar(50) Null;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add Valid_To_Cd_42_Display Nvarchar(50) Null;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add Cus_type_No_Display Nvarchar(50) Null;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add Cus_type_Desc_Display Nvarchar(50) Null;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add Addr1_Display Nvarchar(50) Null;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add Addr2_Display Nvarchar(50) Null;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add Addr3_Display Nvarchar(50) Null;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add Addr4_Display Nvarchar(50) Null;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK add PostCode_Display Nvarchar(50) Null;
</code>