How to see schema's objects in Mgt. Studio? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

How to see schema's objects in Mgt. Studio?

Author

Topic

Tritim
Starting Member

17 Posts

Posted - 2008-06-19 : 20:28:13

Hi all,

I'm working with a SQL 2005 database built a couple of years ago by someone else.

There a couple of schemas in it named after two developers from way back who are long gone from the company. For example a schema named jjohnson.

My question is this:
Using Management Studio, How can I tell if there are any objects "contained" in that schema named jjohnson? (I want to delete it.)

Any help will be appreciated.

Tritim

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-06-19 : 21:15:10

select ss.name, so.name
from sys.objects so
join sys.schemas ss on ss.schema_id=so.schema_id
where ss.name='jjohnson'

Tritim
Starting Member

17 Posts

Posted - 2008-06-20 : 11:04:10

jezemine,

That worked. Just what I needed.
Many thanks.

Tritim

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources