====== Microsoft - Microsoft SQL Server - SQL - Columns - Drop Columns ======

<code sql>
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN Cd_Schedule_41_License_Number;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN Valid_From_Cd_41;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN Valid_To_Cd_41;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN Cd_Schedule_42_License_Number;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN Valid_From_Cd_42;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN Valid_To_Cd_42;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN Cus_type_No;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN Cus_type_Desc;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN Addr1;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN Addr2;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN Addr3;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN Addr4;
alter table dbo.dcsINGRES_CD_Licenses_41_42_FullConstruct_W01_UK DROP COLUMN PostCode;
</code>