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

Posted by

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

Advertisements

Leave a Reply

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

WordPress.com Logo

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

Google photo

You are commenting using your Google 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.