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)
-
Google url shortener service, goo.gl , is now much improved with newly included features like easier copy and paste, and ability to delete e...
-
If you have been reading the mainstream media or the social media, it is likely that you would have heard of SimplyGo - an initiative by the... -
LinkScanner , which AVG launched as a free product, performs real-time scanning of webpages as users browse and blocks those pages that may ...
-
The below is LTA's official MRT map that includes both current and future train network. -
ActiveSG is a national initiative from the Singapore government to encourage all to stay healthy and keeping fit. Membership registration i...
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