Skip to content

Instantly share code, notes, and snippets.

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