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 )?標(biāo)識,
?( 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 ?長度,
? 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 ?字段說明?

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 ?a.id,a.colorder