Add a column to a table if it does not exits
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'TblSourceMaster' AND COLUMN_NAME = 'CorpSourceId')
BEGIN
ALTER TABLE TblSourceMaster ADD CorpSourceId bigint NULL
END
No comments:
Post a Comment