querying table Structure SQL

Tag: Object text where State outer scom desc code default value

1 SELECT    Case  whenCol.colorder= 1  ThenObj.nameELSE "' END  asTable name, Col.colorder asSerial number, Col.name ascolumn name,2                 ISNULL(Ep.value, N"') asColumn description, T.name asData type, Col.length asLengthISNULL(ColumnProperty(Col.id, Col.name,3                 ' Scale'),0) asNumber of decimal digits, Case  when ColumnProperty(Col.id, Col.name,'isidentity') 4                 = 1  Then '√' ELSE "' END  asIdentity Case  when EXISTS5(SELECT   16                       fromDbo.sysindexes siINNER JOIN7Dbo.sysindexkeys Sik onSi.id=Sik.id andSi.indid=Sik.indidINNER JOIN8Dbo.syscolumns SC onSc.id=Sik.id andSc.colid=Sik.colidINNER JOIN9Dbo.sysobjects so onSo.name=Si.name andSo.xtype= 'PK'Ten                      WHERESc.id=Col.id andSc.colid=Col.colid) Then '√' ELSE "' END  asprimary KEY, One                  Case  whenCol.isnullable= 1  Then '√' ELSE "' END  asAllow NULL,ISNULL(Comm.textN"') asDefault Value A  fromsyscolumns asCol Left OUTER JOIN -Systypes asT onCol.xtype=T.xusertypeINNER JOIN -sysobjects asObj onCol.id=Obj.id andObj.xtype= 'U'  andObj.status>= 0  Left OUTER JOIN thesyscomments asComm onCol.cdefault=Comm.id Left OUTER JOIN -Sys.extended_properties asEp onCol.id=ep.major_id andCol.colid=ep.minor_id and  -Ep.name= 'ms_description'  Left OUTER JOIN -Sys.extended_properties asEptwo onObj.id=eptwo.major_id andeptwo.minor_id= 0  and  +Eptwo.name= 'ms_description' - WHERE(Obj.name= 'tb_room_state') + ORDER  bySerial number

querying table Structure SQL