Friday, 13 March 2009

List view/table/storedprocedure details including creation, modify date

This system tables allow you to see the list of views, tables, stored procedures in the database as well as information like creation, modify date.

SELECT * FROM MyDb.sys.views
SELECT * FROM MyDb.sys.tables
SELECT * FROM MyDb.sys.procedures

No comments:

Post a Comment