--Andrew D. Smith 
 declare @tbname varchar(200)
 select @tbname = 'inventory'


 drop table #toWiki
 select convert(varchar(255),'||{T^!C4TW80^}' + @tbname + '||') as txt, -2 as odr  into #toWiki


 insert into #toWiki VALUES('||{!}Column||{!}Allow Nulls||{!}Type||{!}Description||',-1)


 insert into #toWiki
  SELECT '||[' + C.COLUMN_NAME  + ']||'+ 
  C.IS_NULLABLE  + '||[' + C.DATA_TYPE + ']||' + 
  convert(varchar(10), COALESCE (CHARACTER_MAXIMUM_LENGTH,NUMERIC_PRECISION ))
  +  '|| ||',C.ORDINAL_POSITION 
  FROM INFORMATION_SCHEMA.Tables T JOIN INFORMATION_SCHEMA.Columns C
  ON T.TABLE_NAME = C.TABLE_NAME
  WHERE T.TABLE_NAME NOT LIKE 'sys%'
  AND T.TABLE_NAME <> 'dtproperties'
  AND T.TABLE_SCHEMA <> 'INFORMATION_SCHEMA'
  and t.table_name=@tbname0


 select txt from #toWiki order by odr

See Inventory for an example

If you are working with Microsoft SqlServer 2000 you can recover the description stored in the column property with this script

 --Andrew D. Smith 
 declare @tbname varchar(200)
 select @tbname = 'CG_00_SCADENZE'


 drop table #toWiki
 select convert(varchar(255),'||{T^!C4TW80^}' + @tbname + '||') as txt, -2 as odr  into #toWiki


 insert into #toWiki VALUES('||{!}Column||{!}Allow Nulls||{!}Type||{!}Description||',-1)


 insert into #toWiki
  SELECT '||[' + 
    C.COLUMN_NAME  + ']||'+ 
    C.IS_NULLABLE  + '||[' + 
    C.DATA_TYPE + ']||' + 
    convert(varchar(10), COALESCE (CHARACTER_MAXIMUM_LENGTH,NUMERIC_PRECISION ))+  '||' +
    convert(varchar(100), ExtP.Value) + '||'
    ,C.ORDINAL_POSITION 
  FROM INFORMATION_SCHEMA.Tables T INNER JOIN 
        INFORMATION_SCHEMA.Columns C  ON T.TABLE_NAME = C.TABLE_NAME INNER JOIN
        ::fn_listextendedproperty ('MS_Description', 'user', 'dbo', 'table', @tbname, 'column', default) ExtP ON
        C.COLUMN_NAME = ExtP.objname
  WHERE T.TABLE_NAME NOT LIKE 'sys%'
  AND T.TABLE_NAME <> 'dtproperties'
  AND T.TABLE_SCHEMA <> 'INFORMATION_SCHEMA'
  and t.table_name=@tbname

 select txt from #toWiki order by odr

Original Contribution by AndrewDSmith