Recent Posts

Sql Server 2005 Tips and Tricks

Get some unique tips tricks and articles on SQL Server 2005. The blogs also cover Sql Server Reporting Services along with SQL Server Administration

Find out all the views in a database using SQL Server 2005

Posted on Sunday May 11th, 2008 at 00:18 in views, database

In order to find out all the views in a database, use this query :USE AdventureWorksGOSELECT [name] AS ViewName,create_date as CreationDate,modify_date as ModificationDateFROM sys.viewsORDER BY ViewNameGOYou can also get various other info like Schem...