microsoft:microsoft_sql_server:sql:columns:add_columns
This is an old revision of the document!
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;
microsoft/microsoft_sql_server/sql/columns/add_columns.1628092703.txt.gz · Last modified: 2021/08/04 15:58 by peter