Skip to content

Instantly share code, notes, and snippets.

@souhaiebtar

souhaiebtar/util_sql_query.sql

Created November 30, 2022 11:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save souhaiebtar/5dd85dac4106a869fbfca0d781136429 to your computer and use it in GitHub Desktop.
Save souhaiebtar/5dd85dac4106a869fbfca0d781136429 to your computer and use it in GitHub Desktop.
Download ZIP
[util sql query] util sql query #sql #util #db
Raw
util_sql_query.sql
-- list all tables that have column with name 'ID_CAT'
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('ID_CAT')
AND TABLE_SCHEMA='ppgt01';
--
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment