#查看表注释
SELECT a.table_name 表名,CASE WHEN TABLE_COMMENT = ‘’ THEN COLUMN_COMMENT ELSE TABLE_COMMENT END 表注释
FROM INFORMATION_SCHEMA.TABLES AS a
INNER JOIN INFORMATION_SCHEMA.COLUMNS AS b ON a.table_schema = ‘huhu’ AND
a.table_schema = b.table_schema AND a.table_name = b.table_name AND b.column_name = ‘id’
需要有一定SQL基础哟。
如何查询数据库所有表的表名
最新推荐文章于 2024-03-18 09:39:02 发布