Announcements
No record found.
What is the difference between select table and select * from table?
Hi brian,
There is not much difference between the two select statements. I think both will return the same results.
Refer to the below microsoft documentation.
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/xpp-data/xpp-select-statement
Thanks,
Girish S.
It's the same. By the way, you can verify such things by yourself by looking at the resulting SQL code. For example:
ATable aTable; select generateOnly aTable; info(aTable.getSQLStatement());
Hi brianmaric,
There is a similar discussion here that you can refer to, and generally there are no hard and fast rules.
stackoverflow.com/.../is-there-a-difference-between-select-and-select-list-each-col
The link is about a different topic: whether to select all fields by * or to explicitly name fields to select.
This thread is about two different ways how to select all fields. select table and select * from table results in identical SQL query.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 509 Super User 2026 Season 1
Giorgio Bonacorsi 375
Adis 268 Super User 2026 Season 1
