Browse by Tags

All Tags » information sch... » system » tsql   (RSS)
Ways to make best use of INFORMATION_SCHEMA Views - Stored procedures & Functions?
15 October 07 05:59 AM | SQL Master | 2 Comments   
How many of you took help from using INFORMATION_SCHEMA views in SQL Server? Have you ever wondered in returning the informaiton of a Stored procedure or function, you may be thinking using SP_HELPTEXT would get you. Parts of the solution is yes with Read More...
TSQL methods to display the owner of schema in a database.
15 August 07 02:23 AM | SQL Master | 2 Comments   
You can use 2 methods to get information about owner of a particular schema or set of schema(s) within the database. Using INFORMATION_SCHEMA views method (which I prefer most of the times): USE <DBName> GO SELECT * FROM INFORMATION_SCHEMA.SCHEMATA Read More...