Is there anyway to check if one field exists in different tables?

Question

I want to check if there is one particular field exists in different table using one query only?

For example, I have 3 tables, with many fields. I want to check if field A in table 1 exists in table 2 and table 3.

How can I do it?

Many thanks!

use EXISTS command, https://stackoverflow.com/questions/133031/how-to-check-if-a-column-exists-in-a-sql-server-table — unobatbayar, Mar 09 '21 at 05:41
https://cloud.google.com/bigquery/docs/information-schema-tables — astentx, Mar 09 '21 at 05:41

score 3 · Answer 1 · answered Mar 09 '21 at 05:40

3

You can use COLUMNS view:

SELECT *
FROM my_dataset.INFORMATION_SCHEMA.COLUMNS
WHERE column_name = "fieldA_name"
  and table_name in ("table1_name", "table2_name", "table3_name")

answered Mar 09 '21 at 05:40

Sergey Geron

9,098
2
22
29

Is there anyway to check if one field exists in different tables?

1 Answers1