list schemas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

annecarterfredi@gmail.com - 30 Aug 2006 14:58 GMT

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

Reply to this Message

Serge Rielau - 30 Aug 2006 15:06 GMT

> 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

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

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

Reply to this Message

Gladiator - 30 Aug 2006 16:10 GMT

> > 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
[quoted text clipped - 13 lines]
> IOD Conference
> http://www.ibm.com/software/data/ondemandbusiness/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

Reply to this Message

Serge Rielau - 30 Aug 2006 16:32 GMT

>>> 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
[quoted text clipped - 20 lines]
> this will list all the schema's available corresponding to the database
> ... ....

What's wrong with that?

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

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

Reply to this Message