Query the last modification time and Creation Time of the database (table modification time)

Query the last modification time and Creation Time of the database (table modification time)

Query the last modification time and Creation Time of the database (table modification time)

Query the last modification time and Creation Time (table modification time)

// Query the last modification time of the database: 2005
Select modify_date from sys. objects where object_id = object_id ('table _ name ')

Select modify_date from sys. objects where object_id = object_id ('table _ name ')

// Last modification time of the table
Select * from sysobjects
// Only the creation date can be found.

Select * from sys. databases