SELECT
@Rownum := @Rownum + 1 序号,
COLUMN_NAME 列名,
COLUMN_TYPE 数据类型,
COLUMN_TYPE 长度,
'' 小数位,
'' 标识,
CASE
WHEN COLUMN_KEY = 'PRI' THEN
'是' ELSE ''
END AS 主键,
CASE
WHEN IS_NULLABLE = 'NO' THEN
'是' ELSE ''
END AS "非空",
COLUMN_DEFAULT 默认值,
COLUMN_COMMENT 说明
FROM
( SELECT @rownum := 0 ) r,
INFORMATION_SCHEMA.COLUMNS
WHERE
table_schema = '库名'
AND table_name = '表名'
ORDER BY
COLUMN_KEY DESC;
sql 生成数据库设计文档
最新推荐文章于 2023-07-27 12:43:53 发布