Solved

Table Owner

Posted on 2013-06-06
3
305 Views
Last Modified: 2013-06-06
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
Comment
Question by:Jeff1976
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 3

Expert Comment

by:tsnirone
ID: 39226306
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
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 500 total points
ID: 39226841
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
 
LVL 3

Expert Comment

by:tsnirone
ID: 39226930
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question