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

Comments

Popular posts from this blog

Parse XML to dynamic object in C#

C# Crop white space from around the image