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

ALTER TABLE dbo.dcsAAH_and_Enterprise_Reps_FullConstruct_W01_UK
ADD S NVARCHAR(30) NULL;

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;