How to select all tables that has a column / columns:
SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('column1','column2') AND TABLE_SCHEMA='database_name';
Post a Comment
I’m Amir Iskander
Working on complex, multi layered projects. Building web services, connecting platforms and designing / developing new functionalities. I'm passionate about researching for new tools and experimenting with ideas, coding through the night for a fun PoC-s or just solve problems.
Goal orientated and focused on solving real business problems and increase business value with web technology.
I expect to associate myself with a professionally driven, well-respected organization by pursuing a challenging, responsible, dynamic and rewarding career and applying my knowledge, expertise, skills and enthusiasm; which will assist my career development and contribute effectively to the progress of the organization and the society as well.