Following query will selects only matching columns in two different tables.
select distinct column_name ,data_type,is_nullable, character_maximum_length
FROM information_schema.COLUMNS
WHERE table_name='TableName1' OR table_name = 'TableName2'
GROUP BY column_name,data_type,is_nullable, character_maximum_length HAVING COUNT(*)>1