Tags: database, microsoft, modified, mysql, oracle, server, sql, structure, table, time

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

On Database » Microsoft SQL Server

702 words with 2 Comments; publish: Fri, 04 Jan 2008 11:07:00 GMT; (25031.25, « »)

Hi

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

Regs

Sandeep

All Comments

Leave a comment...

  • 2 Comments
    • I don't know of a way in SQL 2000, but in 2005 you can find it in sys.tables
      #1; Fri, 04 Jan 2008 11:09:00 GMT
    • 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

      FROMINFORMATION_SCHEMA.ROUTINES

      WHERECreated <> Last_Altered

      ORDER BY Last_Altered

      How To find tables in a database with modified structure:

      selectname,create_date,modify_date from sys.tables

      WHEREcreate_date <> modify_date

      ORDER BY modify_Date

      #2; Fri, 04 Jan 2008 11:10:00 GMT