Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
