Database Checking

[Rajesh]

Hi,

Assume in the database we have a table named "X".
I have Created or added a new column to the table "X".
Now I want to insert a check point to ensure the Newely created column is added to the table.

Could some one let me know your comments.
Is it possible?????

[Ankur]

Two ways,

1) check for the column --- select xyz from table if column exist it will show you the data else it will raise an error. Use err object to raise and capture the error ( if it occurs)

2) Other method can be to download the table before and after inserting the column in excel and use getparametercount to get the no of columns each time. If diff is 1 then the column is inserted.

I would prefer the 1st method. 2nd, In my opinion is not efficient.