Create markdown based on table metadata in SQL Server / SQL DW / Azure SQL

tablemeta.sql

select 'header' as tablename,0 as colid, '|id|name|type|length|' as markdown
UNION ALL
select 'header2' as tablename, 0 as colid, '|---|---|---|---|' as markdown
UNION ALL
select  o.name as tablename, c.colid, convert(varchar(10),c.colid) + '|'+c.name+'|'+ t.name +'|' + convert(varchar(10),c.length) + '|' as markdown
from sysobjects o 
inner join syscolumns c on c.id = o.id
inner join systypes t on t.xtype = c.xtype
where o.name = 'mytable'
order by tablename, colid