DON'T EDIT THIS QUERY! YOU HAVE LINKED TO IT FROM HERE: http://meta.stackexchange.com/a/2678/158100 REMEMBER?
Q&A about the site for professional and independent game developers
select c.Table_Name , c.column_name , k.* from INFORMATION_SCHEMA.Columns c inner join INFORMATION_SCHEMA.KEY_COLUMN_USAGE k on k.table_name = c.table_name