当前位置: 数据库>sqlserver
select查询表的字段属性及注释内容
来源: 互联网 发布时间:2014-08-29
本文导语: 本节主要内容: select语句查询表的字段属性及注释内容 sql语句: 代码示例: SELECT column_name AS `列名`, data_type AS `数据类型`, character_maximum_length AS `字符长度`, numeric_precision AS `数字长度`, numeric_scale AS `小数位数`, is_nu...
本节主要内容:
select语句查询表的字段属性及注释内容
sql语句:
代码示例:
SELECT
column_name AS `列名`,
data_type AS `数据类型`,
character_maximum_length AS `字符长度`,
numeric_precision AS `数字长度`,
numeric_scale AS `小数位数`,
is_nullable AS `是否允许非空`,
CASE WHEN extra = 'auto_increment'
THEN 1 ELSE 0 END AS `是否自增`,
column_default AS `默认值`,
column_comment AS `备注`
FROM
Information_schema.columns
WHERE
table_Name='mytable_name';
column_name AS `列名`,
data_type AS `数据类型`,
character_maximum_length AS `字符长度`,
numeric_precision AS `数字长度`,
numeric_scale AS `小数位数`,
is_nullable AS `是否允许非空`,
CASE WHEN extra = 'auto_increment'
THEN 1 ELSE 0 END AS `是否自增`,
column_default AS `默认值`,
column_comment AS `备注`
FROM
Information_schema.columns
WHERE
table_Name='mytable_name';
代码说明:
查询Information_schema.columns中的信息,以获取table_Name='mytable_name';表的字段属性与注释内容。
修改select查询指定的表名即可,有兴趣的朋友可以亲测一下。