Tuesday, August 23, 2016

Add new Column in Existing Table


IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS         
WHERE TABLE_NAME = 'tblName' AND COLUMN_NAME = 'ColumnName')         
BEGIN         
  ALTER TABLE tblName ADD ColumnName nvarchar(60)        
END

No comments:

Post a Comment