Finding Shared Columns in SQL Server
- by smoore
Is there a quick query I can run that returns all columns of the same name between two tables?
I have many pairs of tables that I know are tied together, but I'm not sure which of the 50 or so columns they have in common.