Posted by Erland Sommarskog on 11/28/06 22:38

vajarov (vajarov@gmail.com) writes:
> I am pretty happy with the new system views in SQL 2005 but there is
> one thing I could not figure out: What is the view that let you see
> what object belongs to what DB? Sorry for the simple question, Cheers,

I'm not really sure that I understand it. Objects are either server-bound
or database-bound. And if it's database-bound, the object is referred to
by db.schema.name. If you have a single-part name like 'mytable', then
that object belongs to the current database. (There are some exceptions
when it comes to the system views itself, but let's ignore that.)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: UPDATE JOIN TOP 1
• Prev in forum: Re: Default "Auto Close" to no for entire server?
• Thread view: Re: SQL Server 2005 objects question

[Reply to this message]