Schemas in a Database

Shefu · #1 (**permalink**) 07-21-06, 02:17

Hi,

Syscat.Tables gives all the information about the Tables that exist in a database

I wanna know which system table has the information about all the schema in a database.

Thanks
Sn

Marcus_A · #2 (**permalink**) 07-21-06, 02:33

The DB2 system catalog views are described in the SQL Reference Vol 1, Appendix D.

rahul_s80 · #3 (**permalink**) 07-21-06, 04:46

these are not tables.. they are views
you can get details about schema in syscat.schemata.

thanks,
Rahul

Shefu · #4 (**permalink**) 07-21-06, 04:53

Thanks Marcus,

SYSCAT.SCHEMATA contains the details about the schemas in a database.

Cheers
Sn

Internet Services

Web Development

Digital Marketing

Consumer Tech