DBA DB2:Everything
DBA Scripts

Search dba-db2.com

Follow dba-db2.com

*Use the Comments section for questions

Daily & Exclusive Content

DB2 list schemas of a database

11 July,2011 by Tom Collins

"How to do a DB2 list schemas ?"

Step 1 – Connect to the database

db2 connect to my_database

Step 2 – Execute this query

select schemaname from syscat.schemata

If you want to connect to another schema - read DB2 SET CURRENT SCHEMA

The recordset is something like :

DB2 SET CURRENT SCHEMA - DBA DB2

ADMIN_DROP_SCHEMA to drop a schema - DBA DB2

how to grant select privileges on all tables for DB2

Author: Rambler(http://www.dba-db2.com)

Share:

Posted by Tom Collins at 8:20 AM in DBA Scripts, Object Management | Permalink | Comments (4) | TrackBack (0)

Searches: database schema, db2 database schema, db2 list, db2 list schemas, db2 list schemas, list schema, schema in db2, set schema, set schema db2

How to connect to the schema ?

Posted by: Pradeep | Apr 12, 2013 12:04:46 AM

Hi Pradeep , you can use the SET CURRENT SCHEMA . More details on : http://www.dba-db2.com/2012/01/db2-set-current-schema.html

Posted by: Jack Vamvas | Apr 13, 2013 12:07:50 AM

HI I need list of schemas in specific database

Posted by: Akhil | May 27, 2016 11:39:23 PM

Akhil, To get a list of schemas for a specific database, use Step 1 and Step 2 on this post.
http://www.dba-db2.com/2011/07/db2-list-schemas-of-a-database.html

Posted by: Jack Vamvas | Jun 1, 2016 4:51:56 AM

Verify your Comment

Previewing your Comment

Posted by: |

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:

Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.