Sql Server 2008获取表的注释,字段名,字段类型,字段描述等,代码自动生成必备
来源:互联网 发布:左轮吉他淘宝店 编辑:程序博客网 时间:2024/05/22 11:51
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 parent_obj=a.id 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.xusertype=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='tab_user' --如果只查询指定表,加上此条件
order by
a.id,a.colorder
================================
SELECT
tableName = case when a.colorder=1 then d.name else '' end,
tableNameDescribe = case when a.colorder=1 then isnull(f.value,'') else '' end,
fieldNo = a.colorder,
fieldName = a.name,
isKey = case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end,
isKeyMain = case when exists(SELECT 1 FROM sysobjects where xtype='PK' and parent_obj=a.id 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,
fieldType = b.name,
fieldByteLength = a.length,
fieldLength = COLUMNPROPERTY(a.id,a.name,'PRECISION'),
pointDigits = isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0),
allowEmpty = case when a.isnullable=1 then '√'else '' end,
fieldDefault = isnull(e.text,''),
fieldDescript = isnull(g.[value],'')
FROM
syscolumns a
left join
systypes b
on
a.xusertype=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='ElearningUser'
order by
a.id,a.colorder
- Sql Server 2008获取表的注释,字段名,字段类型,字段描述等,代码自动生成必备
- 读取sql server表的字段名,字段类型,字段长度,字段属性描述的sql语句
- 读取sql server表的字段名,字段类型,字段长度,字段属性描述的sql语句
- 读取sql server表的字段名,字段类型,字段长度,字段属性描述的sql语句
- 读取sql server表的字段名,字段类型,字段长度,字段属性描述的sql语句
- 查询sql server表的字段、注释、类型等信息
- 查询sql server表的字段、注释、类型等信息
- 查询sql server表的字段、注释、类型等信息
- 如何获取SQL Server所有的数据库名、表名、字段名及字段类型?
- 读取sql server表的字段名,字段类型,字段长度,字段属性的sql语句
- 读取sql server表的字段名,字段类型,字段长度,字段属性的sql语句
- sql server查询表的字段名和字段类型
- postgresql 获取所有表名、字段名、字段类型、注释
- SQL Server 2008获取一个表的字段,类型,长度,是否主键,是否为空,注释等信息
- SQL Server 2008获取一个表的字段,类型,长度,是否主键,是否为空,注释等信息
- SQL Server 2008获取一个表的字段,类型,长度,是否主键,是否为空,注释等信息
- 通过sql语句 获取表的所有字段名 类型等属性
- sql如何获得某个数据库里面的表的字段名,字段类型,字段长度(sql server)
- HTTP协议头部与Keep-Alive模式详解
- ios 中如何应对UIScrollView快速滑动(暴力用户,暴力测试)
- Connection:Keep-alive
- UNOjava组件的创建流程
- GBin1专题之Web热点#10
- Sql Server 2008获取表的注释,字段名,字段类型,字段描述等,代码自动生成必备
- HTTP Keep-Alive详解
- VMware+Windgb+Win7内核驱动调试
- RAC-ORA-15055: unable to connect to ASM instanceORA-12547: TNS:lost contact
- bootloader 详细介绍
- android的窗口机制分析------ViewRoot类
- Java中的多线程
- C++ 标准模板库组件介绍
- javascript事件列表解说