You’re offline. This is a read only version of the page.
Announcements
Hi Everyone,
Using below SQL query I can get the Table Id,
select * from SysTableIdView where Name = 'CustTable'
Can anyone please help me with SQL query to get field Ids of all fields of a particular table? This is possible and I have done this long time back, so unable to recall it.
I don't want to fetch field Id of a single field. I want the list of all field names and their IDs.
Thank you in advance.
Table and field IDs are technical IDs that are intended for D365 internal usage. As long as you're working inside D365, you can use the mentioned views in x++ to get the info. And if you're working outside D365, then table and field ids should be irrelevant.
Please let us know what is your functional requirement. Thanks!
Why would you do that?
Please tell us what you're trying to achieve from business point of view. We can't suggest a meaningful technical design without knowing what you need to achieve.
Hi Andre,
Then how could we identify the IDs for UAT and Production environment? As we don't have SQL access of UAT and Production in D365, do I need to write X++ job for same?
Hi Rhushikesh,
A small additional comment. Note that the IDs can be different in each environment.
Thank you Nikolaos for quick response.
I am able to fetch field Ids with below query now.
select * from SysTableFieldIdView where SysTableFieldIdView.Id = '77'
In above Query, SysTableFieldIdView.Id (77) is a Table Id
#1
André Arnaud de Cal...
293,344
Super User 2025 Season 1
#2
Martin Dráb
232,445
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (