Creating Table/View from SQL query

(0) Share

Report

Posted on by JHickey

Hello all!

I am very new to AX and am looking to create a table or view from an SQL statement that I have written. I was told this is possible but can't seem to find any information on it.

Anybody have any insights or done this before?

Thanks in advance!

-Jeff

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

XB 1,875 on at

Like (0)

Report
Copy link

Link copied!

It's very easy to create a new table in ax and you don't need to execute sql statement.

Check the link below

AXLearn

Was this reply helpful? Yes No
Verified answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi JHickey,

It does not work this way in AX. In AX you need to create new table or view in AOT and when you will synch, AX will create table\view in SQL database.

Was this reply helpful? Yes No
JHickey 95 on at

Like (0)

Report
Copy link

Link copied!

Well that is unfortunate. Thanks for your reply!

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

You _could_ create new objects in the AX database, but whether you _should_ is a different question.

Anything that is not reflected within the AX AOT are simply not visible (unless you write custom code to retrieve it through ODBC connection, which is horrible idea due to many reasons). Always create everything in the AOT.

Was this reply helpful? Yes No