February 19, 2024 at 6:50 pm
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy