Thursday, November 3, 2022

Get table/ field name from id and vice versa

Get Table name from table id :

SELECT NAME

  FROM SQLDICTIONARY

  WHERE TABLEID = 9669 AND FIELDID = 0


Table id from table name :

SELECT TABLEID

  FROM SQLDICTIONARY

  WHERE NAME = 'PurchTable' AND FIELDID = 0


Field name from field id :

SELECT NAME

  FROM SQLDICTIONARY

  WHERE FIELDID = 87 AND

             TABLEID = 9669


Field id from field name :

SELECT FIELDID

  FROM SQLDICTIONARY

  WHERE NAME = 'PurchId' AND

             TABLEID = 9669