DON'T EDIT THIS QUERY! YOU HAVE LINKED TO IT FROM HERE: http://meta.stackexchange.com/a/2678/158100 REMEMBER?
Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences
select c.Table_Name , case when ##PK:string?id## = c.column_name then concat(c.column_name,' (PK)') else c.column_name end as column_name , data_type , is_nullable , coalesce(CHARACTER_MAXIMUM_LENGTH , numeric_precision , datetime_precision) as [Length/precision] ,* from INFORMATION_SCHEMA.Columns c where c.table_name = ##table:string?posts## order by ordinal_position