会员
周边
众包
新闻
博问
闪存
所有博客
当前博客
我的博客
我的园子
账号设置
简洁模式
...
退出登录
注册
登录
代码改变世界
Cnblogs
Dashboard
Login
Home
Contact
Gallery
Subscribe
RSS
安谷
读取数据库所有字段及备注
2009-09-16 16:37
E世年华
阅读(
121
) 评论(
0
)
编辑
收藏
举报
Code
1
SELECT
sysobjects.name
AS
TableName, syscolumns.name
AS
ColumnsName,
2
systypes.name
AS
DateType, syscolumns.length
AS
DateLength,
3
sysproperties.
[
value
]
AS
Remark
4
FROM
sysproperties
RIGHT
OUTER
JOIN
5
sysobjects
INNER
JOIN
6
syscolumns
ON
sysobjects.id
=
syscolumns.id
INNER
JOIN
7
systypes
ON
syscolumns.xtype
=
systypes.xtype
ON
8
sysproperties.id
=
syscolumns.id
AND
9
sysproperties.smallid
=
syscolumns.colid
10
WHERE
(sysobjects.xtype
=
'
u
'
OR
11
sysobjects.xtype
=
'
v
'
)
AND
(systypes.name
<>
'
sysname
'
)
12
ORDER
BY
TableName
会员力量,点亮园子希望
刷新页面
返回顶部
About