SQL Server查找何时重命名表?

时间:2021-10-27 08:51:11

Is it possible to find out when a table was renamed? (as a primary question) And if possible which user did it?

是否有可能知道何时重命名了一个表?(主要问题)如果可能的话,是哪个用户做的?

1 个解决方案

#1


6  

You can try this:

你可以试试这个:

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

#1


6  

You can try this:

你可以试试这个:

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