SELECT t.object_id AS 'TableID', t.name AS 'TableName', s.schema_id AS 'SchemaID', s.name AS 'SchemaOwner' FROM sys.tables t inner join sys.schemas s ON t.schema_id = s.schema_id ORDER by t.name
Wednesday, March 20, 2013
MSSQL: Get schema owner of database tables
To retrieve a list of schema owner of database tables, try the following code snippet. Hope it help.s
Subscribe to:
Post Comments (Atom)
-
Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed m...
-
For people who like to stream US/UK stuff but don't want to pay VPN, try Hola . They have support for Windows, Android, Chrome, Firefox ...
-
If you have never heard of the case of Cambridge Analytica with Facebook, then you must be living in some cave. Ever since the scandal was... -
Forbes named Singapore Prime Minister wife and CEO of Temasek Holdings, Ho Ching, as the 5th most powerful woman in the world . Ho Ching is ... -
To coincide with the current movie screening of Disney's Dumbo, I present you the main song for Dumbo. Enjoy! Lyrics Baby mine, do...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.