USE database_name
去
SELECT tab.name ,,,,,,, AS 表
得到,sys.columns 坳
,,,,,,INNER JOIN sys.tables 选项卡
,,,,,,,,,,,,,,,col.object_id =tab.object_id
,,,,,,LEFT JOIN sys.extended_properties 每
,,,,,,,,,,,,,,col.column_id =per.minor_id
,,,,,,,,,,,,,,,,以及per.major_id =tab.object_id
,,,,,,INNER JOIN sys.types 类型
,,,,,,,,,,,,,,,col.user_type_id =type.user_type_id
group by tab.name
ORDER , BY tab.name
USE database_name
去
SELECT tab.name ,,,,,,, AS 表名,
,,,,,,col.name ,,,,,,, AS column_name,
,,,,,,per.value ,,,,,, AS column_comment,
,,,,,,col.is_identity AS column_key,
,,,,,,type.name ,,,,,, AS data_type,
,,col.max_length AS column_length
得到,sys.columns 坳
,,,,,,INNER JOIN sys.tables 选项卡
,,,,,,,,,,,,,,,col.object_id =tab.object_id
,,,,,,LEFT JOIN sys.extended_properties 每
,,,,,,,,,,,,,,col.column_id =per.minor_id
,,,,,,,,,,,,,,,,以及per.major_id =tab.object_id
,,,,,,INNER JOIN sys.types 类型
,,,,,,,,,,,,,,,col.user_type_id =type.user_type_id
ORDER , BY tab.name,
,,,,,,,,,col.is_identity DESC
USE database_name
去
SELECT ,,,,
,,,,,,,表名=case when a.colorder=1, then d.name else “,,,,,
,,,,,,,表说明=case when a.colorder=1, then isnull (f.value,”), else “,,,,,,
,,,,,,,字段序号=a.colorder,,,,,
,,,,,,,字段名=a.name,,,,,
,,,,,,,标识=case when COLUMNPROPERTY (, a.id、a.name IsIdentity)=1, then “√”else “,,,,,
,,,,,,,主键=case when 存在(SELECT 1,得到sysobjects where xtype=癙K”,以及name 拷贝(,,,,
,,,,,,,,,,,SELECT name 得到sysindexes WHERE indid 在(,,,,
,,,,,,,,,,,,,,,SELECT indid 得到sysindexkeys WHERE id =, a.id 以及colid=a.colid ,,,
,,,,,,,,,,,))),then “√”, else “,,,,,
,,,,,,,类型=b.name,,,,,
,,,,,,,占用字节数=a.length,,,,,
,,,,,,,长度=COLUMNPROPERTY (a.id a.name,“精度”),,,,,
,,,,,,,小数位数=isnull (COLUMNPROPERTY (a.id a.name,“规模”),0),,,,,
,,,,,,,允许空=case when a.isnullable=1, then “√”else “,,,,,
,,,,,,,默认值=isnull (e.text”),,,,,
,,,,,,,字段说明=isnull (g。(价值)”),,,,
null
null
null
null
null
null
null
null
