效果如下:
1,在对应库中执行如下查询,不带标题复制查询结果,
SELECT CASE WHEN col.colorder = 1 THEN '</table><h3>'+obj.name+':'+cast( ISNULL(epTwo.[value],'') as
varchar(1000))+'</h3><table class="gridtable">
<th>序号</th><th>列名</th><th>列说明</th><th>数据类型</th><th>长度</th><th>小数位数</th><th>标识</
th><th>主键</th><th>允许空</th><th>默认值</th>'
ELSE ''
END AS 表名,
'<tr><td>' +cast(col.colorder as varchar(100)) +'</td>'AS 序号 ,
-- '<td>'+col.name+'</td>' AS 列名 ,
'<td>'+cast(col.name as varchar(100))+'</td>' AS 列名 ,
'<td>' + cast(ISNULL(ep.[value], '')as varchar(100)) +'</td>' AS 列说明 ,
'<td>' +cast( t.name as varchar(100)) +'</td>' AS 数据类型 ,
'<td>' +cast( col.length as varchar(100)) +'</td>' AS 长度 ,
'<td>' + cast( ISNULL(COLUMNPROPERTY(col.id, col.name, 'Scale'), 0) as varchar(100)) +'</td>'AS 小数位数 ,
CASE WHEN COLUMNPROPERTY(col.id, col.name, 'IsIdentity') = 1 THEN '<td>√</td>'
ELSE '<td></td>'
END AS 标识 ,
CASE WHEN EXISTS ( SELECT 1
FROM dbo.sysindexes si
INNER JOIN dbo.sysindexkeys sik ON si.id = sik.id
AND si.indid = sik.indid
INNER JOIN dbo.syscolumns sc ON sc.id = sik.id
AND sc.colid = sik.colid
INNER JOIN dbo.sysobjects so ON so.name = si.name
评论1