db2 list tables for schema的命令是什么
1个回答
展开全部
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>
本回答由网友推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
