How to Get table field properties and comments in Sql2008

How do I get table field properties and comments in Sql2008?

Select B.[value] From Sys.columns a left join Sys.extended_properties B on a.object_id=b.major_id

and a.column_id=b.minor_id inner join sysobjects C on a.column_id=c.id

and a.[name]= ' column name ' and c.[name]= ' table name '

SELECT

Table name =case when a.colorder=1 then D.name else "end,

Table Description =case When a.colorder=1 then IsNull (F.value, ' ") Else ' end,

Field Ordinal =a.colorder,

Field name =a.name,

Identify =case when ColumnProperty (A.id,a.name, ' isidentity ') =1 then ' √ ' Else ' end,

Primary key =case when exists (SELECT 1 to sysobjects where xtype= ' PK ' and name in (

SELECT name from sysindexes WHERE indid in (

SELECT indid from Sysindexkeys WHERE id = a.id and colid=a.colid

)) Then ' √ ' Else ' end,

Type =b.name,

Bytes occupied =a.length,

Length =columnproperty (a.id,a.name, ' PRECISION '),

Decimal Places =isnull (ColumnProperty (a.id,a.name, ' Scale '), 0),

Allow empty =case when a.isnullable=1 then ' √ ' Else ' end,

Default value =isnull (E.text, ""),

Field Description =isnull (G.[value], "")

From Syscolumns A

Left join Systypes B on A.xusertype=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 Sys.extended_properties G on a.id=g.major_id and a.colid=g.minor_id

Left join Sys.extended_properties F on d.id=f.major_id and f.minor_id=0

--where d.name= ' orders '--if only the specified table is queried, plus this condition

ORDER BY A.id,a.colorder