write a query that applies to an entire db instead of a table

Question

Is it possible to write a query that applies to an entire database as opposed to one table.

So instead of usin:

 select * from table_name where columnName = ?

Can I say select * db_tables from from db where the table contains the column A?

Is is possible? thanks

score 3 · Accepted Answer · answered Sep 07 '17 at 01:59

3

You sure can!

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME like '%A'

answered Sep 07 '17 at 01:59

zambonee

thanks for the help @zambonee...iv hit another wall if you could be on any help that would be great https://stackoverflow.com/questions/46107078/query-returning-wrong-value – John Sep 08 '17 at 00:54

score 0 · Answer 2 · answered Sep 07 '17 at 01:58

0

You cannot do SELECT * FROM all the tables, but you can run a query aganist multiple tables using other statements in SQL.

answered Sep 07 '17 at 01:58

Sai

2 Answers2