Browse by Tags

All Tags » catalog » tsql   (RSS)
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...