rohit.anshu (5/2/2013)

---

hi,

I just came across an error, the cause of which is unknown to me.

why would a TSQL :

-----------------------------------------------------------------------

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'Schema1' AND TABLE_NAME = 'Table1' AND COLUMN_NAME = 'Column1')

BEGIN

ALTER TABLE Schema1.Table1 ADD Column1 int NULL

UPDATE Schema1.Table1

SET Column1 = -1

ALTER TABLE Schema1.Table1 ALTER COLUMN Column1 int NOT NULL

END

------------------------------------------------

throw an error:

Msg 207, Level 16, State 1, Line 5

Invalid column name 'Column1'.

while running the update command.