query table, field, type, whether primary key, length, decimal place, whether NULL is allowed, default value, and so on detailed query

Small fruit

SELECT    ( Case  whenA.colorder=1  ThenD.nameElse "' End) asTable name,--returns null if the table name is the sameA.colorder asfield ordinal, A.name asfield name, ( Case  when ColumnProperty(A.id,a.name,'isidentity')=1  Then '√'Else "' End) asidentification, ( Case  when(SELECT Count(*) fromsysobjects--Query primary Key                     WHERE(Nameinch                               (SELECTName fromsysindexesWHERE(ID=a.ID) and(indidinch                                       (SELECTIndid fromSysindexkeysWHERE(ID=a.ID) and(colidinch                                           (SELECTColid fromsyscolumnsWHERE(ID=a.ID) and(Name=( a.name) ))))) and(xtype= 'PK'))>0  Then '√' Else "' End) asPrimary KEY,--Query primary key endB.name astype, A.length asthe number of bytes consumed,ColumnProperty(A.id,a.name,'PRECISION') aslength,IsNull(ColumnProperty(A.id,a.name,' Scale'),0) asNumber of decimal digits, ( Case  whenA.isnullable=1  Then '√'Else "' End) asallow NULL,IsNull(E.text,"') asdefault value,IsNull(g.[value],"') asField Description fromSyscolumns A Left Joinsystypes b onA.xtype=B.xusertypeInner Joinsysobjects D ona.ID=D.id andD.xtype='U'  andD.name<>'dtproperties'    Left Joinsyscomments e onA.cdefault=e.id Left Joinsys.extended_properties G ona.ID=g.major_id andA.colid=g.minor_idOrder  byA.id,a.colorder

Query table, field, type, whether primary key, length, decimal place, whether NULL is allowed, default value, and so on detailed query