ORACLE数据库的方法
取表名。[登陆的用户需有访问的权限]
SELECT * FROM User_tables where tablespace_name='FPHC'
取字段COMMENT
SELECT TABLE_NAME, COLUMN_NAME, COMMENTS
FROM USER_COL_COMMENTS
WHERE TABLE_NAME = 'MR_DEPT'
取表的说明
SELECT * FROM USER_TAB_COMMENTS WHERE TABLE_NAME = 'MR_DEPT'
取字段的数据类型
SELECT * FROM USER_TAB_COLUMNS
WHERE TABLE_NAME='WZ_ZBGG'