How to detect a column rename?

Question

How to detect a column rename?

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

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

ratbak Default port Points: 1423 More actions · Answer 1

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.

Mauricio_ SSCrazy Points: 2935 More actions · Answer 2

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.