SQL Server Performance

How can i find when column is added in table?

Discussion in 'SQL Server 2005 General DBA Questions' started by mssql_dba_123, May 4, 2009.

  1. mssql_dba_123 New Member

    Hi All,
    Is there any way to find out when particular column is added in table?
    Thanks in advance..
  2. Adriaan New Member

    You can use a DDL trigger to track changes of this kind (but only from the moment the trigger is in place).
  3. mssql_dba_123 New Member

    Is there any other way to find out the same without using trigger?
  4. Adriaan New Member

    There's always the option to depend on developers and DBAs to maintain proper documentation about everything they do ...
  5. dhamu294 New Member

    use if exists in syscolumn to find weather the column already exists or not. else create it.

Share This Page