MySQL获取查询数据库表结构备注等信息


查询数据库中的表

SELECT
-- a.*,
TABLE_NAME AS 表名,
TABLE_COMMENT AS 备注,
TABLE_ROWS as 数据条数
FROM
INFORMATION_SCHEMA.TABLES a
where
a.table_type = 'BASE TABLE'
and TABLE_SCHEMA = '数据库名' 
order by TABLE_NAME

查询表的结构

SELECT
ORDINAL_POSITION as 序号,
-- TABLE_SCHEMA as 表名,
	COLUMN_NAME AS 字段名,
	DATA_TYPE AS 数据类型,
	NUMERIC_PRECISION as 精度,
	CHARACTER_MAXIMUM_LENGTH as 长度,
	IS_NULLABLE as 空,
	COLUMN_COMMENT AS 注释
FROM
	INFORMATION_SCHEMA.COLUMNS a
WHERE
	TABLE_SCHEMA ='数据库名'

AND TABLE_NAME = '表名'
order by ORDINAL_POSITION

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注