HOW to check for last modified time of a table Structure in SQL Server

[sandepmohan]

Hi
I just want ot know when a table structure was modified last time in SQL SERVER? Please help ASAP

Regs
Sandeep

[iburyak]

I don't know of a way in SQL 2000, but in 2005 you can find it in sys.tables

[johngaltaz]

Applies to: SQL Server 2005:


How To find modified Stored Procedures:

SELECT Specific_Catalog,
Specific_Name,
Routine_Catalog,
Routine_Type,
Routine_Definition,
Created,
Last_Altered
FROM INFORMATION_SCHEMA.ROUTINES
WHERE Created <> Last_Altered
ORDER BY Last_Altered


How To find tables in a database with modified structure:

select name,create_date,modify_date from sys.tables
WHERE create_date <> modify_date
ORDER BY modify_Date

[Saurabh Sinha]

Hi
This is not always correct beacause modify_date:--> Date the object was last modified by using an ALTER statement. If the object is a table or a view, modify_date also changes when a clustered index on the table or view is created or altered.

Saurabh Sinha