Friday, March 8, 2019

D365 table name from tableid

Open SQL MSSMS and run the following script with a sought number.


SELECT 
   [ID]
      ,[NAME]
      ,[RECVERSION]
      ,[RECID]
  FROM [AxDB].[dbo].[TABLEIDTABLE]
  where id = 1459

No comments: