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)
-
This post contains information about registration for Wireless@SG account. Sign Up You can sign up a total of 3 user accounts, one each ...
-
Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed m...
-
The Mashable published 10 Chrome extensions for web developers and I bet web developers like you yourself must be using some of them. Do yo...
-
Since Google Reader started 8 years ago, I have been a great fan of it, using it on a daily basis. It is indeed sad to hear we will have to ...
-
Gartner Report on the Magic Quadrant for Analytics and Business Intelligence Platforms as of February 2021.
Choose your favorite image from your device gallery or capture the real picture with your smartphone camera to create a drawing photo sketch & pencil sketch photo editor & set some stylish color drawing effect and sparkle effect. When you make a beautiful pencil sketch of your image then you feel it’s the best photo sketch - convert photo to sketch app and sparkle effect in the world.
ReplyDelete