Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Table names with design modified date

Author  Topic 

binto
Yak Posting Veteran

59 Posts

Posted - 2010-11-10 : 02:41:48
I have a DB named TEST with 600 tables.I have modified some of the table's design.How can i get the recently design modified table names?
please help me

Thanks & Regards
Binto Thomas

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-11-10 : 02:52:08
SELECT Name AS [Table Name] FROM sys.tables ORDER BY Modify_Date DESC

Vaibhav T

If I cant go back, I want to go fast...
Go to Top of Page
   

- Advertisement -