SELECT

表名=casewhena.colorder=1thend.nameelse''end,

表說明=casewhena.colorder=1thenisnull(f.value,'')else''end,

字段序號=a.colorder,

字段名=a.name,

標識=casewhenCOLUMN

主鍵=casewhenexists(SELECT1FROMsysobjectswherextype='PK'andnamein(

SELECTnameFROMsysindexesWHEREindidin(

SELECTindidFROMsysindexkeysWHEREid=a.idANDcolid=a.colid

)))then'√'else''end,

類型=b.name,

占用字節數=a.length,

長度=COLUMNPROPERTY(a.id,a.name,'PRECISION'),

小數位數=isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0),

允許空=casewhena.isnullable=1then'√'else''end,

默認值=isnull(e.text,''),

字段說明=isnull(g.[value],'')

FROMsyscolumnsa

leftjoinsystypesbona.xusertype=b.xusertype

innerjoinsysobjectsdona.id=d.idandd.xtype='U'andd.name<>'dtproperties'

leftjoinsyscommentSEOna.cdefault=e.id

leftjoinsys.extended_propertiesgona.id=g.major_idanda.colid=g.minor_id

leftjoinsys.extended_propertiesfond.id=f.major_idandf.minor_id=0

whered.name='CJ_Products_bak'--如果只查詢指定表,加上此條件

orderbya.id,a.colorder