Discussion in 'SQL Server 2005 General DBA Questions' started by mssql_dba_123, May 4, 2009.
Is there any way to find out when particular column is added in table?
Thanks in advance..
You can use a DDL trigger to track changes of this kind (but only from the moment the trigger is in place).
Is there any other way to find out the same without using trigger?
There's always the option to depend on developers and DBAs to maintain proper documentation about everything they do ...
use if exists in syscolumn to find weather the column already exists or not. else create it.
Separate names with a comma.