时间:2019-12-02来源:电脑系统城作者:电脑系统城
USE DBNAME
--指定要生成数据字典的数据库
GO
SELECT
表名=
CASE
WHEN
a.colorder= 1
THEN
d.
name
ELSE
''
END
, 表说明=
CASE
WHEN
a.colorder= 1
THEN
isnull
( f.value,
''
)
ELSE
''
END
, 字段序号= a.colorder, 字段名= a.
name
, 标识=
CASE
WHEN
COLUMNPROPERTY( a.id, a.
name
,
'IsIdentity'
) = 1
THEN
'√'
ELSE
''
END
, 主键=
CASE
WHEN
EXISTS (
SELECT
1
FROM
sysobjects
WHERE
xtype =
'PK'
AND
name
IN
(
SELECT
name
FROM
sysindexes
WHERE
indid
IN
(
SELECT
indid
FROM
sysindexkeys
WHERE
id = a.id
AND
colid = a.colid ) )
)
THEN
'√'
ELSE
''
END
,
类型= b.
name
,
占用字节数= a.length,
长度= COLUMNPROPERTY( a.id, a.
name
,
'PRECISION'
),
小数位数=
isnull
( COLUMNPROPERTY( a.id, a.
name
,
'Scale'
), 0 ),
允许空=
CASE
WHEN
a.isnullable= 1
THEN
'√'
ELSE
''
END
,
默认值=
isnull
( e.text,
''
),
字段说明=
isnull
( g.[value],
''
)
FROM
syscolumns a
LEFT
JOIN
systypes b
ON
a.xtype= b.xusertype
INNER
JOIN
sysobjects d
ON
a.id= d.id
AND
d.xtype=
'U'
AND
d.
name
<>
'dtproperties'
LEFT
JOIN
syscomments e
ON
a.cdefault= e.id
LEFT
JOIN
sys.extended_properties g
ON
a.id= g.major_id
AND
a.colid= g.minor_id
LEFT
JOIN
sys.extended_properties f
ON
d.id= f.major_id
AND
f.minor_id = 0
--where d.name='要查询的表' --如果只查询指定表,加上此条件
ORDER
BY
a.id,
a.colorder
2023-03-15
SQLserver存储过程写法与设置定时执行存储过程方法详解2023-03-11
sql语句将数据库一条数据通过分隔符切割成多列方法实例2023-03-06
MySQL中的常用树形结构设计总结最详细的 SQLSERVER ALWAYSON配置教程 一、准备工作: 二、搭建故障转移群集 三、搭建数据库AlwaysOn 四、过程中可能遇到的问题...
2023-03-06
2.1破解的时候,先要断网,然后再操作,按如图打开界面,点击Manage License 2.2点击Activate 2.3打开SQL.Prompt.Keygen.exe,将生成的注册码拷贝到输入框内,然后点击Activate 2.4 继续点击Activate manually 2.5 按如下步骤操...
2023-03-06