topic Is there a way to set SQL mode as the default for a definition query? in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/is-there-a-way-to-set-sql-mode-as-the-default-for/m-p/1052444#M40360 <P>I basically always prefer to use SQL instead of the query builder when creating/modifying a layer's definition query, but as far as I can tell, there is no setting in the ArcGIS Pro options to turn off the query builder and make SQL the default. That means that it takes 2 mouse clicks to switch to SQL mode:</P><P>1. Click 'Edit'.</P><P>2. Click the SQL slider.</P><P>It would be great if clicking 'Definition Query' in the layer properties would open the SQL pane with no extra clicks. Am I missing the setting for this?</P> Wed, 28 Apr 2021 20:07:48 GMT Dan_Call 2021-04-28T20:07:48Z Is there a way to set SQL mode as the default for a definition query? https://community.esri.com/t5/arcgis-pro-questions/is-there-a-way-to-set-sql-mode-as-the-default-for/m-p/1052444#M40360 <P>I basically always prefer to use SQL instead of the query builder when creating/modifying a layer's definition query, but as far as I can tell, there is no setting in the ArcGIS Pro options to turn off the query builder and make SQL the default. That means that it takes 2 mouse clicks to switch to SQL mode:</P><P>1. Click 'Edit'.</P><P>2. Click the SQL slider.</P><P>It would be great if clicking 'Definition Query' in the layer properties would open the SQL pane with no extra clicks. Am I missing the setting for this?</P> Wed, 28 Apr 2021 20:07:48 GMT https://community.esri.com/t5/arcgis-pro-questions/is-there-a-way-to-set-sql-mode-as-the-default-for/m-p/1052444#M40360 Dan_Call 2021-04-28T20:07:48Z Re: Is there a way to set SQL mode as the default for a definition query? https://community.esri.com/t5/arcgis-pro-questions/is-there-a-way-to-set-sql-mode-as-the-default-for/m-p/1052479#M40363 <P>There is a related idea that you may wish to champion</P><P><A href="https://community.esri.com/t5/arcgis-pro-ideas/application-wide-setting-option-to-switch-between-quot-clause/idi-p/935401" target="_blank">Application wide setting / option to switch betwee... - Esri Community</A></P> Wed, 28 Apr 2021 20:42:19 GMT https://community.esri.com/t5/arcgis-pro-questions/is-there-a-way-to-set-sql-mode-as-the-default-for/m-p/1052479#M40363 DanPatterson 2021-04-28T20:42:19Z Re: Is there a way to set SQL mode as the default for a definition query? https://community.esri.com/t5/arcgis-pro-questions/is-there-a-way-to-set-sql-mode-as-the-default-for/m-p/1617122#M95950 <P>In ArcGIS Pro 3.5, this is now an optional project setting!&nbsp; On the Project tab -&gt; Map and Scene Tab -&gt; Query Builder category, for the Default query builder mode, you can set it to SQL Editor Mode.&nbsp; Then your default mode is to write SQL!</P> Wed, 21 May 2025 17:01:30 GMT https://community.esri.com/t5/arcgis-pro-questions/is-there-a-way-to-set-sql-mode-as-the-default-for/m-p/1617122#M95950 Robert_LeClair 2025-05-21T17:01:30Z