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


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


 insert into #toWiki VALUES('||{!}Table Name||{!} ||{!} ||{!}Description||',-1)


 insert into #toWiki 
 select '||[' + TABLE_NAME + ']||' + CASE TABLE_TYPE
         WHEN 'BASE TABLE' THEN '(*)||[Table'
         ELSE '(i)||[View'
      END + ']||||', 2 from information_schema.tables t
 WHERE T.TABLE_NAME NOT LIKE 'sys%'
 AND T.TABLE_NAME <> 'dtproperties'
 AND T.TABLE_SCHEMA <> 'INFORMATION_SCHEMA'


 insert into #toWiki VALUES('',5)
 insert into #toWiki VALUES('SqlToGenerateTableListWiki',6)


 select txt from #toWiki order by odr

Example

Tables in Database
Table Name			Description
Inventory		View
Pub		Table

:SQLDictionary:

Original Contribution by AndrewDSmith