By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,279 Members | 1,673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,279 IT Pros & Developers. It's quick & easy.

list schemas

P: n/a
what is the command to list all existing schemas in a database? Is
there any command to list all the schemas under a instance as
database.schema ??
Please let me know. Thanks,

A Carter

Aug 30 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
an*************@gmail.com wrote:
what is the command to list all existing schemas in a database? Is
there any command to list all the schemas under a instance as
database.schema ??
Please let me know. Thanks,
There is a view with the obvious name.
There is no way to peek into any SQL object at an INSTANCE level.
You need to connect to a database.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Aug 30 '06 #2

P: n/a

Serge Rielau wrote:
an*************@gmail.com wrote:
what is the command to list all existing schemas in a database? Is
there any command to list all the schemas under a instance as
database.schema ??
Please let me know. Thanks,
There is a view with the obvious name.
There is no way to peek into any SQL object at an INSTANCE level.
You need to connect to a database.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
ya ... we need to connect to database and then give

"db2 select schemaname from syscat.schemata ".....

this will list all the schema's available corresponding to the database
.... ....
Regards
Kamal

Aug 30 '06 #3

P: n/a
Gladiator wrote:
Serge Rielau wrote:
>an*************@gmail.com wrote:
>>what is the command to list all existing schemas in a database? Is
there any command to list all the schemas under a instance as
database.schema ??
Please let me know. Thanks,
There is a view with the obvious name.
There is no way to peek into any SQL object at an INSTANCE level.
You need to connect to a database.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/

ya ... we need to connect to database and then give

"db2 select schemaname from syscat.schemata ".....

this will list all the schema's available corresponding to the database
... ....
What's wrong with that?
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Aug 30 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.