How to check table Id in Dynamics 365 for Finance and Operations – SQL Server

Scenario: Sometimes developer needs table id of the table to use in their logic

Solution: you can get the table id for any table using sql query in the development environment.

SysTableIdView is the table from where you can fetch the Id.

Below is the query


select * from SysTableIDView

Screen Shot 2019-11-03 at 12.54.54 PM.png

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.