[SQL Server] 导出表结构(数据字典)

-- 数据字典
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
                               &nb