获取网站数据库:获取sql数据库所有表结构来源: 发布时间:星期三, 2008年12月24日 浏览:2次 评论:0
="t18">SELECT
(  when a.colorder=1 then d.name  '' end) N'表名',a.colorder N'字段序号', a.name N'字段名', ( when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√' '' end) N'标识',( 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 '√' '' end) N'主键',b.name N'类型', a.length N'占用字节数', COLUMNPROPERTY(a.id,a.name,'PRECISION') as N'长度', isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0) as N'小数位数', ( when a.isnullable=1 then '√' '' end) N'允许空',isnull(e.text,'') N'默认值', isnull(g.[value],'') AS N'字段介绍说明' 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 sysproperties g on a.id=g.id AND a.colid = g.smallid order by object_name(a.id),a.colorder 可以将以上代码放到SQL查询分析器上运行  下就知道了(当然要打开个数据库啦)
0
相关文章
读者评论
发表评论 |
 |
专注于互联网--专注于架构 |
最新标签 网站地图 文章索引 Rss订阅 |
