sql server读取备注信息
- 2017-06-26 12:23:00
- 1147533288 原创
- 1753
sql server读取备注信息
"SELECT o.name as tableName,c.name as columnName,p.value as Description FROM sysproperties p join sysobjects o on o.id=p.id
join syscolumns c on p.id=c.id and p.smallid=c.colid where p.name='MS_Description' and o.name = 'yourtable'order by 1";
"SELECT o.name as tableName,c.name as columnName,p.value as Description FROM sysproperties p join sysobjects o on o.id=p.id
join syscolumns c on p.id=c.id and p.smallid=c.colid where p.name='MS_Description' and o.name = 'yourtable'order by 1";
获取sqlserver中的所有数据库，数据表，列，备注说明
--1.获取所有数据库名:
SELECT Name FROM Master..SysDatabases ORDER BY Name
--2.获取所有表名:
SELECT Name FROM ..SysObjects Where XType='U' ORDER BY Name
--XType='U':表示所有用户表;
--XType='S':表示所有系统表;
--3.获取所有字段名及说明:
SELECT syscolumns.name,sysproperties.[value] AS Comment
FROM sysproperties INNER JOIN sysobjects ON sysproperties.id = sysobjects.id
INNER JOIN syscolumns ON sysobjects.id = syscolumns.id AND sysproperties.smallid = syscolumns.colid
WHERE (sysproperties.type = 4) AND (sysobjects.name = 'jobs ')
SELECT Name FROM Master..SysDatabases ORDER BY Name
--2.获取所有表名:
SELECT Name FROM ..SysObjects Where XType='U' ORDER BY Name
--XType='U':表示所有用户表;
--XType='S':表示所有系统表;
--3.获取所有字段名及说明:
SELECT syscolumns.name,sysproperties.[value] AS Comment
FROM sysproperties INNER JOIN sysobjects ON sysproperties.id = sysobjects.id
INNER JOIN syscolumns ON sysobjects.id = syscolumns.id AND sysproperties.smallid = syscolumns.colid
WHERE (sysproperties.type = 4) AND (sysobjects.name = 'jobs ')
文章分类
联系我
| 联系人： | meepo |
|---|---|
| 电话： | ***** |
| Email： | 1147533288@qq.com |
| QQ： | 1147533288 |