获取数据库表、表字段、表注释、字段注释
1.获取表
Oracle:
1 | select table_name from user_tables; //当前用户的表 table_name,tablespace_name,last_analyzed等 |
2.获取表字段
Oracle:
1 | select * from user_tab_columns where Table_Name='用户表'; |
3.获取表注释
Oracle:
1 | select * from user_tab_comments where Table_Name='用户表'; |
4.获取字段注释
Oracle:
1 | select * from user_col_comments where Table_Name='用户表'; |
MySQL:
1 | select * from information_schema.COLUMNS where table_name = '表名' and table_schema = '数据库名' |
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | EcoGeoDB | azhdcd | STTYBH | 1 | NO | varchar | 19 | 57 | utf8 | utf8_bin | varchar(19) | PRI | select,insert,update,references | 统一编号 |
号 |
本博客所有文章除特别声明外,均采用 CC BY-NC-SA 4.0 许可协议。转载请注明来自 WineMonk!
评论