怎樣才能導(dǎo)出SQL所有用戶表的字段信息

問(wèn)題：怎樣才能導(dǎo)出SQL所有用戶表的字段信息？
    解答：請(qǐng)使用下面的Sql語(yǔ)句：
    SELECT
    (case when a.colorder=1 then d.name else '' end)表名,
    a.colorder 字段序號(hào),
    a.name 字段名,
    (case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end) 標(biāo)識(shí),
    (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 占用字節(jié)數(shù),
    COLUMNPROPERTY(a.id,a.name,'PRECISION') as 長(zhǎng)度,
    isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0) as 小數(shù)位數(shù),
    (case when a.isnullable=1 then '√'else '' end) 允許空,
    isnull(e.text,'') 默認(rèn)值,
    isnull(g.[value],'') AS 字段說(shuō)明
    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