Mysql查询表注释和字段注释信息

 

 

MySQL查询表注释和字段注释信息

-- 查询表注释
select table_schema, table_name, table_comment from information_schema.tables where table_schema = 'xxx' and table_name = 'xxx';


-- 查询表字段注释
select table_schema, table_name, column_name, column_comment from information_schema.columns where table_schema = 'xxx' and table_name = 'xxx';

 

记录备查