Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/SHOW_EXTERNAL_TABLES_IN_DATABASE.sql

Created July 28, 2021 12:46
Show Gist options
  • Save vvgsrk/b01a96a3b8dfd73c525551aff576e5c8 to your computer and use it in GitHub Desktop.
Save vvgsrk/b01a96a3b8dfd73c525551aff576e5c8 to your computer and use it in GitHub Desktop.
Download ZIP
Lists the external tables for which you have access privileges
Raw
SHOW_EXTERNAL_TABLES_IN_DATABASE.sql
SHOW EXTERNAL TABLES LIKE 'infare_external_table' IN DATABASE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment