microsoft:microsoft_sql_server:sql:columns:drop_columns
Microsoft - Microsoft SQL Server - SQL - Columns - Drop Columns
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;
microsoft/microsoft_sql_server/sql/columns/drop_columns.txt · Last modified: 2021/08/05 11:29 by peter