查看表结构:
看字段名与数据类型
SELECT * FROM COLS WHERE TABLE_NAME = UPPER('TABLE_NAME');
查看主键:
SELECT * FROM USER_CONSTRAINTS WHERE CONSTRAINT_TYPE = 'P'
AND TABLE_NAME=UPPER( 'TABLE_NAME');
另外:
在SQLPLUS中,用 desc tablename
在PL/SQL工具中,可以通过视图user_tab_columns 查看
SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME = UPPER('TABLE_NAME');
查看备注:
--查看表的comment
SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = UPPER('TABLE_NAME');
--查看列的comment
SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = UPPER('TABLE_NAME');