SQL queries the example of the table, stored procedure, trigger Creation Time, and last modification time. The creation time is modified.

SQL queries the example of the table, stored procedure, trigger Creation Time, and last modification time. The creation time is modified.

-- Query creation time -- table select * from sysobjects where id = object_id (n'table name ') and xtype = 'U' -- select * from syscolumns where id = object_id (N 'table name ') -- stored procedure select * from sysobjects where id = object_id (N 'dqtx ') and xtype = 'P' -- query the last modification time -- stored procedure select name, modify_date from sys. all_objects where name = 'stored procedure 'and type = 'P' order by modify_date desc -- trigger select name, modify_date from sys. all_objects where name = 'stored procedure 'and type = 'tr' order by modify_date desc -- table select * from sys. all_objects where name = 'stored procedure 'and type = 'U' order by modify_date desc