【数据库查询表结构】

mysql中查询库下表名与数据量

select
table_name 表名,table_comment 表注释,table_rows 数据量
from information_schema.tables
where table_schema = ‘lajzqz’
order by table_name;

mysql中查询库下字段名与字段注释

select
column_name 字段名,column_type 字段类型,column_comment 字段注释 ,table_name 表名
from information_schema.columns a
where table_schema=‘lajzqz’
order by table_name;

oracle中查询库下表名与数据量

select
a.table_name,b.comments,a.num_rows
from user_tables a,user_tab_comments b
where a.table_name=b.table_name
order by table_name;

oracle中查询库下字段名与字段注释

select *
from user_col_comments;