db2数据库查询语句

DB2数据库常用查询语句

DB2数据库常用查询:

1. DB2查找存储过程语句,存储过程名字大写。SELECT PROCNAME,TEXT,CREATE_TIME,A. * FROM SYSCAT.PROCEDURES a WHERE PROCNAME = 'TEST_AAA' with ur;

2. DB2数据库查找一个表的索引语句。SELECT * from syscat.indexes where tabname=upper( 'TEST_AAA' ) with ur;

3. DB2数据库查看属于哪个表空间语句。SELECT tabname, tbspace from syscat.tables where tabname=upper( 'TEST_AAA' ) with ur;