find a schema by owner - SQL Server Forums

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 2000 Forums

Transact-SQL (2000)

find a schema by owner

Author

Topic

grizzlee
Starting Member

6 Posts

Posted - 2008-04-22 : 08:02:20

hi
How can i find a schema when i only now it's owner and the database where it is.I need to read it into a variable

select * from sys.schemas where...?

thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-22 : 08:10:23

Books Online is a very nice feature to have.
I suggest you install it too!

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA

E 12°55'05.25"
N 56°04'39.16"

grizzlee
Starting Member

6 Posts

Posted - 2008-04-22 : 08:25:46

Hi
thanks for the quick answer.I had Online books installed but i did not know what to search after because i am new in this domain.

thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources