https://community.esri.com/t5/geodatabase-questions/why-are-query-layer-names-limited-to-158/m-p/1377963#M8848 <P>The&nbsp;<A href="https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/configure-database-and-clients-for-query-layers.htm" target="_self">Database and client configurations for query layers</A> say:</P><BLOCKQUOTE><P>Query layer names are limited to 158 characters. When adding a feature class or table from a database connection in the <SPAN class="">Catalog</SPAN> pane or Catalog view to the map, the default name used for the query layer is the fully qualified name of the table. If the fully qualified name of the source table in the database or cloud data warehouse contains more than 158 characters, adding it to the map from the <SPAN class="">Catalog</SPAN> pane or Catalog view will fail. In these cases, use the <SPAN class="">New Query Layer</SPAN> dialog box to create a query layer, and define a query layer name that contains fewer than 158 characters.</P></BLOCKQUOTE><P>Why 158 characters? That number seems arbitrary.</P> Sun, 04 Feb 2024 11:54:52 GMT Bud 2024-02-04T11:54:52Z https://community.esri.com/t5/geodatabase-questions/why-are-query-layer-names-limited-to-158/m-p/1377963#M8848 <P>The&nbsp;<A href="https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/configure-database-and-clients-for-query-layers.htm" target="_self">Database and client configurations for query layers</A> say:</P><BLOCKQUOTE><P>Query layer names are limited to 158 characters. When adding a feature class or table from a database connection in the <SPAN class="">Catalog</SPAN> pane or Catalog view to the map, the default name used for the query layer is the fully qualified name of the table. If the fully qualified name of the source table in the database or cloud data warehouse contains more than 158 characters, adding it to the map from the <SPAN class="">Catalog</SPAN> pane or Catalog view will fail. In these cases, use the <SPAN class="">New Query Layer</SPAN> dialog box to create a query layer, and define a query layer name that contains fewer than 158 characters.</P></BLOCKQUOTE><P>Why 158 characters? That number seems arbitrary.</P> Sun, 04 Feb 2024 11:54:52 GMT https://community.esri.com/t5/geodatabase-questions/why-are-query-layer-names-limited-to-158/m-p/1377963#M8848 Bud 2024-02-04T11:54:52Z https://community.esri.com/t5/geodatabase-questions/why-are-query-layer-names-limited-to-158/m-p/1377970#M8849 <P><A href="https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/enterprise-geodatabase-limits.htm" target="_blank">Enterprise geodatabase size and name limits—ArcGIS Pro | Documentation</A></P><P>might be tied into the 159 character limit imposed on feature datasets <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Sun, 04 Feb 2024 14:24:28 GMT https://community.esri.com/t5/geodatabase-questions/why-are-query-layer-names-limited-to-158/m-p/1377970#M8849 DanPatterson 2024-02-04T14:24:28Z