Friday, July 5, 2013

Check Column exists in table, if not, add


Check For a Column Exists In A Table If Not Add

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TableName' AND COLUMN_NAME ='ColumnName')

BEGIN

ALTER TABLE TableName ADD ColumnName varchar(50) NULL

END
Posted by at

2 comments:

  1. chitharancomMay 26, 2014 at 6:33 AM

    bdfg

    ReplyDelete
  2. UnknownFebruary 5, 2020 at 12:01 PM

    Thanks for a very interesting blog. What else may I get that kind of info written in such a perfect approach? I’ve a undertaking that I am simply now operating on, and I have been at the look out for such info. script cek mutasi

    ReplyDelete

Subscribe to: Post Comments (Atom)