3 lines
215 B
Plaintext
3 lines
215 B
Plaintext
IF ((SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ROIPeriodChannels' AND COLUMN_NAME = 'ChannelID') = 0)
|
|
ALTER TABLE [dbo].[ROIPeriodChannels] ADD ChannelId [bigint] NOT NULL DEFAULT 0;
|