Page 1 of 1

How to get Schema name for given table name

PostPosted: Sat Feb 14, 2015 11:33 pm
by sivareddy123
db2 query to retrieve schema names for given table name

Re: How to get Schema name for given table name

PostPosted: Sun Feb 15, 2015 8:09 pm
by Akatsukami
Search column TSNAME in SYSIBM.SYSTABLES where the target table is in column NAME. Note that the schema-table relationship may be many-to-one.