GET table name for table id

 

/* GET table name for table id */
SELECT NAME
FROM SQLDICTIONARY
WHERE TABLEID = 9669 AND FIELDID = 0

Comments

Popular posts from this blog

D365: SSRS Report Development/ Customization

D365: X++ code to add custom lookup on worker to show specific workers team workers only

Dynamics ax 2012: Sample code for fetching records in tmp table using query and Insert record set