how to get all table names from db2 database schema

[noorg]

hi all can you tell me the db2 query for how to get all table names from db2 database schema

[db2sma]

Syscat table

Select varchar(tabname ,40) from syscat.tables

[Sidhartha]

db2 list tables for schema <schema name>
or db2 list tables for all

[Aniket sonmale]

db2 list tables

[pramodds]

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='<sche maname>'"