--Andrew D. Smith (AndrewDSmith)
 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