I am working on an application that we will be using to maintain our database dictionary (description of each column in each table) and would like to build a "Refresh" function that can go to the database and get the updated column list/names.
What i'm having issues with is when a column is renamed/moved, i would like to track if there is way to update the database with the new details. I tried using the "Column_ID" from syscolumns, but this changes when the column is moved so seems to be an arbitrary number. Is there any unique ID that MSSQL generates for a column that doesn't change?
My alteative is to add the new column and mark the old one as removed.
Thanks