web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / WHICH TABLE STORES PRO...
Microsoft Dynamics AX (Archived)

WHICH TABLE STORES PROPERTIES OF ALL TABLES IN AX 2009.

(0) ShareShare
ReportReport
Posted on by Vikas Mehta 21 1,163

Hi Folks,

Can anyone let me know which table stores all the Table's properties data in AX 2009.

I had gone through tables like sysdatabaselog,utilelements,sqlstatistics etc but none of them was helpful.

Any help is highly appreciated.

Thanks,

Vikas Mehta.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Xander Vink Profile Picture
    Xander Vink 2,550 on at

    The table properties as you see in the AOT are not stored in a (SQL) table, but in the AOD files. You can have a look at the utilelements and utilidelements tables. It's easier to use the AOTTreeNode, as you can see at [url]www.axaptapedia.com/index.php[/url]

  • Suggested answer
    Malcolm Burtt Profile Picture
    Malcolm Burtt 1,475 on at

    You can find a list of tables and their fields in the SQLSictionary table. The records in this table that have a field id value of zero are Tables and everything else is a field.

  • Vikas Mehta 21 Profile Picture
    Vikas Mehta 21 1,163 on at

    Thanks Malcolm,

    The data in sql dictionary is about the tables and its corresponding fields and not about its properties.

    I need a table wherein if i change a property of a table say CustTable's modifieddatetime to yes

    this change is recorded in some table which I need to know.

    the SqlDictionary Table has a field as modifiedDateTime  its not showing up in sql as well as table browser .could you let me know how can i do the same.

    Thanks,

    Vikas Mehta.

  • Suggested answer
    Xander Vink Profile Picture
    Xander Vink 2,550 on at

    Please see my earlier reply. The table properties are not stored in a (SQL) table. You can look it up in the utilelements/utilidelements tables, but it's better accessible via the AOTTreeNode.

  • Malcolm Burtt Profile Picture
    Malcolm Burtt 1,475 on at

    Hi Vikas

    You're out of luck there I'm afraid. All the property info is stored in the layer files not the database (all that changed in AX 2012 of course but that's no use to you on AX 2009) so there isn't any way to capture changes in table properties. As already suggested, you can interrogate table properties using the TreeNode and the DictTable classes but they're not going to help implement any kind of trigger based solution that can be auto executed when a property changes.

    The nearest you'd be able to get to logging changes in the way you describe would be to use MorphX source control but even that is not without its problems. With a bit of discipline it might be possible to use it to get some way towards what you want.

    Regards

    Malcolm

  • Vikas Mehta 21 Profile Picture
    Vikas Mehta 21 1,163 on at

    Thanks Malcolm & Xander,

    Utilelements and Utilidelement Table were helpful as I wanted to note the modifieddatetime value.

    Thanks,

    Vikas Mehta.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans