Hi all,

I have a large amount of tables that I would like a query to pull the column names present in these tables that are common between all the tables. 

I know about show columns, but can't seem to use this or another method to achieve this. This will save me from having to manually check large amounts of tables to see what columns are in common.