表结构分析
来源:互联网 发布:如何找回部落冲突数据 编辑:程序博客网 时间:2024/05/15 08:45
SELECT (
CASE WHEN a.colorder=1 THEN d.name ELSE '' END)表名,
a.colorder 字段序号,
a.name 字段名,
(CASE WHEN COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 THEN '√' ELSE '' END) 标识,
(CASE WHEN (
SELECT COUNT(*)
FROM sysobjects
WHERE (name IN
(SELECT name
FROM sysindexes
WHERE (id = a.id) AND (indid IN
(SELECT indid
FROM sysindexkeys
WHERE (id = a.id) AND (colid IN
(SELECT colid
FROM syscolumns
WHERE (id = a.id) AND (name = a.name))))))) AND
(xtype = 'PK'))>0 THEN '√' ELSE '' END) 主键,
b.name 类型,
a.length 占用字节数,
COLUMNPROPERTY(a.id,a.name,'PRECISION') AS 长度,
ISNULL(COLUMNPROPERTY(a.id,a.name,'Scale'),0) AS 小数位数,
(CASE WHEN a.isnullable=1 THEN '√' ELSE '' END) 允许空,
ISNULL(e.text,'') 默认值,
ISNULL(g.[value],'') AS 字段说明
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.major_id
WHERE d.name='tmpa'
ORDER BY a.id,a.colorder
CASE WHEN a.colorder=1 THEN d.name ELSE '' END)表名,
a.colorder 字段序号,
a.name 字段名,
(CASE WHEN COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 THEN '√' ELSE '' END) 标识,
(CASE WHEN (
SELECT COUNT(*)
FROM sysobjects
WHERE (name IN
(SELECT name
FROM sysindexes
WHERE (id = a.id) AND (indid IN
(SELECT indid
FROM sysindexkeys
WHERE (id = a.id) AND (colid IN
(SELECT colid
FROM syscolumns
WHERE (id = a.id) AND (name = a.name))))))) AND
(xtype = 'PK'))>0 THEN '√' ELSE '' END) 主键,
b.name 类型,
a.length 占用字节数,
COLUMNPROPERTY(a.id,a.name,'PRECISION') AS 长度,
ISNULL(COLUMNPROPERTY(a.id,a.name,'Scale'),0) AS 小数位数,
(CASE WHEN a.isnullable=1 THEN '√' ELSE '' END) 允许空,
ISNULL(e.text,'') 默认值,
ISNULL(g.[value],'') AS 字段说明
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.major_id
WHERE d.name='tmpa'
ORDER BY a.id,a.colorder
- OSWorkflow表结构分析
- Sde表结构分析
- OSWorkflow表结构分析
- 表结构分析
- Sde表结构分析
- ecshop表结构分析
- osworkflow 表结构分析
- SDE表结构分析
- ecshop表结构分析
- ecshop表结构分析
- 产品数据库表结构分析
- R12客户表结构分析
- Sqlite表结构简单分析
- activity工作流表结构分析
- 线性表--存储结构分析(结构体定义)
- osworkflow 自带表结构分析
- osworkflow自带表结构分析
- Nginx源码分析---链表结构ngx_list_t
- ping原理及应用
- Hadoop安装指南 / Hive安装指南
- Spring+Hibernate框架下MySql读写分离,主从数据库配置
- C++编程常见错误整理
- mysql必知必会(四) 添加及删除字段
- 表结构分析
- oracle extract()截取时间值函数
- JavaScript中的字符串操作
- SDIO总线 驱动
- android中的ellipsize
- ABRecordRef
- android屏幕旋转时不重新调用onCreate
- Objective-C开发——类、对象和方法解析
- 自动生成MVC模式下的POJO类及hbm.xml文件