SQL Server Find out when the table was renamed?

Question

Can you tell when a table was renamed? (as the main question) And if possible, which user did it?

+3

TSQL_Newbie Apr 17 15 at 7:55

1 answer

kluverua · Answer 1 · 2015-04-17T09:13:43+0000

You can try this:

SELECT Name, modify_date, * FROM sys.all_objects
WHERE Name = 'Table name'