Query table Field Information

String SQL =   String . Format ( @"
Select
Syscolumns. colid,
Sysobjects. Name as [tablename],
Syscolumns. Name as [columnname],
Policypes. Name as [datatype],
Syscolumns. length as [datalength],
SYS. extended_properties. [value] as [description],
Syscomments. Text as [defaultvalue],
Syscolumns. isnullable as [nullable]
From
Syscolumns inner join policypes
On syscolumns. xtype = policypes. xtype
Left join sysobjects on syscolumns. ID = sysobjects. ID
Left Outer Join SYS. extended_properties on
(SYS. extended_properties.minor_id = syscolumns. colid
And SYS. extended_properties.major_id = syscolumns. ID)
Left Outer Join syscomments on syscolumns. cdefault = syscomments. ID
Where syscolumns. ID in
(Select ID from sysobjects where xtype = 'U' and name = '{0}') and (policypes. Name <> 'sysname ')
Order by syscolumns. colid " , Tbname );