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
Computer, Technology, Databases, Google, Internet, Mobile, Linux, Microsoft, Open Source, Security, Social Media, Web Development, Business, Finance
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...
-
This is the Indonesian 2-year old baby who smokes 40 cigarettes a day . He is completely addicted! Visit here to view more of the todd...
-
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...
-
Singapore's Deputy Prime Minister and Finance Minister, Tharman Shanmugaratnam, comment made in parliament on Thursday that household of...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.