469,266 Members | 1,951 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,266 developers. It's quick & easy.

how to get all table names from db2 database schema

1
hi all can you tell me the db2 query for how to get all table names from db2 database schema
Aug 12 '10 #1
4 32152
db2sma
3
Select varchar(tabname,40) from syscat.tables
Aug 15 '10 #2
db2 list tables for schema <schema name>
or db2 list tables for all
Oct 7 '10 #3
db2 list tables
Jan 31 '11 #4
As said before,u can use this
db2 list tables for schema <schema name>
or
query syscat tables.
db2 "select tabname from syscat.tables where tabschem='<schemaname>'"
Feb 5 '11 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by php newbie | last post: by
1 post views Thread by Jens Riedel | last post: by
reply views Thread by jonathan.beckett | last post: by
3 posts views Thread by David C. Barber | last post: by
2 posts views Thread by jack | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.