项目一个简单需求,查询当前用户的所有表,小记一下,以备查询:
查询所有表名:SELECT T.TABLE_NAME||'('||T.COMMENTS||')' TABLE_NAME,T1.COLUMN_NAME FROM USER_TAB_COMMENTS T,USER_TAB_COLUMNS T1 WHERE T1.TABLE_NAME = T.TABLE_NAME AND T.TABLE_TYPE != 'VIEW';
查询指定表名的所有列:SELECT COLUMN_NAME FROM USER_CONS_COLUMNS WHERE CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME = UPPER(?) AND CONSTRAINT_TYPE = 'P')