可以从系统表中取出,下面有很多,需要什么楼主自己挑。:) SELECT * FROM USER_TAB_COLUMNS
SELECT * FROM USER_TAB_COLS
SELECT * FROM USER_TABLES WHERE TABLESPACE_NAME='SYSTEM'
SELECT * FROM USER_TAB_COMMENTS
SELECT * FROM USER_COL_COMMENTS
SELECT USER_TABLES.TABLE_NAME, USER_TAB_COMMENTS.COMMENTS FROM USER_TABLES, USER_TAB_COMMENTS WHERE TABLESPACE_NAME='SYSTEM' AND USER_TABLES.TABLE_NAME = USER_TAB_COMMENTS.TABLE_NAMESELECT USER_TAB_COLUMNS.COLUMN_NAME, USER_TAB_COLUMNS.DATA_TYPE, USER_TAB_COLUMNS.DATA_LENGTH, USER_COL_COMMENTS.COMMENTS FROM USER_TAB_COLUMNS,USER_COL_COMMENTS WHERE USER_TAB_COLUMNS.TABLE_NAME ='REPORTDATASET' AND USER_TAB_COLUMNS.TABLE_NAME = USER_COL_COMMENTS.TABLE_NAME AND USER_TAB_COLUMNS.COLUMN_NAME = USER_COL_COMMENTS.COLUMN_NAME
java.util.Properties prop = new Properties();
prop.setString("user", "username");
prop.setString("password", "password");
prop.setString("res", "true");conn = DriverManager.getConnection(url, prop);然后conn.getMeta().getTables/getColumns就可以获取出注释了
SELECT * FROM USER_TAB_COLUMNS
SELECT * FROM USER_TAB_COLS
SELECT * FROM USER_TABLES WHERE TABLESPACE_NAME='SYSTEM'
SELECT * FROM USER_TAB_COMMENTS
SELECT * FROM USER_COL_COMMENTS
SELECT USER_TABLES.TABLE_NAME,
USER_TAB_COMMENTS.COMMENTS
FROM USER_TABLES,
USER_TAB_COMMENTS
WHERE TABLESPACE_NAME='SYSTEM'
AND USER_TABLES.TABLE_NAME = USER_TAB_COMMENTS.TABLE_NAMESELECT USER_TAB_COLUMNS.COLUMN_NAME,
USER_TAB_COLUMNS.DATA_TYPE,
USER_TAB_COLUMNS.DATA_LENGTH,
USER_COL_COMMENTS.COMMENTS
FROM USER_TAB_COLUMNS,USER_COL_COMMENTS
WHERE USER_TAB_COLUMNS.TABLE_NAME ='REPORTDATASET'
AND USER_TAB_COLUMNS.TABLE_NAME = USER_COL_COMMENTS.TABLE_NAME
AND USER_TAB_COLUMNS.COLUMN_NAME = USER_COL_COMMENTS.COLUMN_NAME