Announcements
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…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. André Arnaud de Cal... 650 Super User 2026 Season 1
Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Abhilash Warrier 287 Super User 2026 Season 1
Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Martin Dráb 225 Most Valuable Professional
