db2 list tables for schema的命令是什么
1个回答
2013-09-12
展开全部
db2 list tables for schema <schema name>
or
all table information is stored in syscat.tables view
db2 select * from syscat.tables where tabschema=<schema name>
or simply
db2 select * from syscat.tables order by tabschema, tabname
similarly, all column information is stored in syscat.columns
db2 select * from syscat.columns where tabname=<table name>
or
all table information is stored in syscat.tables view
db2 select * from syscat.tables where tabschema=<schema name>
or simply
db2 select * from syscat.tables order by tabschema, tabname
similarly, all column information is stored in syscat.columns
db2 select * from syscat.columns where tabname=<table name>
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询