I have 2-3 different column names that I want to look up in the entire DB and list out all tables which have those columns. Any easy script?
To get all tables with columns columnA or ColumnB in the database YourDatabase:
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('columnA','ColumnB')
AND TABLE_SCHEMA='YourDatabase';
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments