Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Table Owner

I am trying to view the owner of the tables inside Microsoft SQL management studio 2005. How can I do that I can not remember. All I see now is
 Name, Schema, and created
0
Jeff1976
Asked:
Jeff1976
  • 2
1 Solution
 
tsnironeCommented:
Been a while since I SQL'd but I think this will work:

use PutYourDBnameHere
go
SELECT b.name FROM sysobjects a, sysusers b
where a.uid = b.uid and a.name like 'PutYourTableNameHere'
and a.type='U'
go

Open in new window


(it might be "a.xtype" and not "a.type" dont recall)

Edit: you must run this inside a query - I think its Ctrl+F or Ctrl+N to open and Ctrl+E to execute.

Hope this helps! :)
0
 
Scott PletcherSenior DBACommented:
When you expand the "Tables" tab under the database, I think the name shows as "<schema_name>.<table_name>": schema_name is the table "owner" in SQL 2005 and later.
0
 
tsnironeCommented:
Things have changed from 2005 it seems :)

However, there seems that schema_name is not always equal table owner....

http://www.sqlservercentral.com/blogs/brian_kelley/2009/03/04/owning-an-object-in-sql-server-2005-2008/

To be blunt, I don't like this capability at all. The ability to do this isn't really talked about a lot in Books Online and I know in the 2005 version there was a lot of confusion when object owner was referenced. When you consider the following, it makes sense: the object owner is, by default, the owner of the schema. If no owner is actually specified for the object, the schema owner is the assumed owner. But you can have an object owner.

If the above is right (and I havent misunderstood) my query would still work....I think..
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now