Share
ReportHello everyone,
I found out that some tables were missing in SQL Management Studio 2014.
Can you please explain the reason? Thanks in advance.
*This post is locked for comments
You’re offline. This is a read only version of the page.
612
Hello everyone,
I found out that some tables were missing in SQL Management Studio 2014.
Can you please explain the reason? Thanks in advance.
*This post is locked for comments
Hi Andre,
Yes,sure. I am not online often on this site, that is why I forgot to set it as answered.
Best regards
Hi Rati,
Thanks for the feedback. Would you mind marking an answer so this question will get the status answered?
Hi Andre,
Once again,your provided information was helpful. Thanks for help.
Hi Rati,
That is true. Some tables are real tables in the AX database. Other tables are views or maybe even stored procedures with a reference to the model database. The example you mentioned is a view as the objects are maintained in the AOT; thus stored in the model DB.
Hi Andre,
But some objects which are in AOT>>System documentation>>Tables, are in the tables list. For example: SecurityUserRole.
Hi Rati,
This is not a table, but a view on the model database. If you are running AX 2012 RTM then the view is on the AX database.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (