Skip to content

Instantly share code, notes, and snippets.

@ztirom

ztirom/GET_table_id_for_table_name Secret

Created December 16, 2017 16:05
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 ztirom/0fa01d7bd84f5746df7811c3bf45f9b0 to your computer and use it in GitHub Desktop.
Save ztirom/0fa01d7bd84f5746df7811c3bf45f9b0 to your computer and use it in GitHub Desktop.
Download ZIP
GET table id for table name
Raw
GET_table_id_for_table_name
/* GET table id for table name */
SELECT TABLEID
FROM SQLDICTIONARY
WHERE NAME = 'PurchTable' AND FIELDID = 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment