T-SQLpowered

ALTER TABLE

Add new column: ALTER TABLE [dbo].[SampleTable] ADD [NewColum_1] NVARCHAR(MAX) — will be added as NULLable ALTER TABLE [dbo].[SampleTable] ADD [NewColum_1] NVARCHAR(MAX) NULL ALTER TABLE [dbo].[SampleTable] ADD [NewColum_1] NVARCHAR(MAX) NOT NULL Change data type for Primary Key column (IDENTITY setting will be persisted): — drop primary key constraint ALTER TABLE [dbo].[SampleTable]…

Read more