Post reply

How to detect a column rename?

  • February 19, 2024 at 6:50 pm

    #4381281

    Hi,

    products like SQL Compare detects if a column has been renamed. To detect new columns, dropped columns or a type or length column is easy, my question is how to detect if a certain column has been renamed.

    Thanks for any ideas.

     

    Mauricio

  • February 19, 2024 at 7:24 pm

    #4381283

    DDL Triggers have a "RENAME" EventType.

    If you want to catch it after the fact using some kind of comparison, then you're probably looking for columns that have the same data type, scale, precision, and ideally, position -- but different names using sys.columns or information_schema.columns.

     

  • February 20, 2024 at 7:20 am

    #4381532

    Position could be an option. However, it's not enough. I've renamed a column and drop another, in a higher position of the renamed and SQL Compare detected the drop and the rename, so it must be something else.

  • March 13, 2024 at 7:29 pm

    This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply