<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>idea Clarify the docs: Create Database View can be used to replace an existing view in ArcGIS Pro Ideas</title>
    <link>https://community.esri.com/t5/arcgis-pro-ideas/clarify-the-docs-create-database-view-can-be-used/idi-p/1277914</link>
    <description>&lt;P&gt;&lt;EM&gt;ArcGIS Pro 3.1.1&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;It looks like the&amp;nbsp;Create Database View geoprocessing tool can be used to &lt;U&gt;&lt;EM&gt;replace&lt;/EM&gt;&lt;/U&gt; a view, not just create a new view.&amp;nbsp;Just use the same name as an existing view: &lt;A href="https://community.esri.com/t5/data-management-ideas/database-views-edit-sql-definition-in-catalog/idc-p/1277895" target="_self"&gt;Idea - Database Views: Edit SQL definition in Catalog&lt;/A&gt;.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_0-1681320404273.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/67790iFAF3863D45F773A2/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Bud_0-1681320404273.png" alt="Bud_0-1681320404273.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You'd never know it's possible to replace a view with that tool from reading the docs:&lt;/P&gt;&lt;BLOCKQUOTE&gt;&lt;P&gt;&lt;A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-view.htm" target="_self"&gt;Create Database View (Data Management)&lt;/A&gt;&lt;/P&gt;&lt;P&gt;Creates a view in a database based on an SQL expression.&lt;/P&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;Could the documentation be improved so that it informs users that creating a database view using the same name as an existing view will replace the view?&lt;BR /&gt;Note: Could&amp;nbsp;&lt;SPAN&gt;it be made clear whether the tool &lt;U&gt;&lt;EM&gt;modifies&lt;/EM&gt;&lt;/U&gt; the existing view or just &lt;U&gt;&lt;EM&gt;deletes&lt;/EM&gt;&lt;/U&gt; it and creates a &lt;U&gt;&lt;EM&gt;new&lt;/EM&gt;&lt;/U&gt; one? For example, in an enterprise geodatabase view, would the privileges that were set up in the view be preserved? Or would they be lost because the view was deleted and recreated?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;Also, should the name of the tool be changed to "Create &lt;STRONG&gt;or Replace&lt;/STRONG&gt; Database View"?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 12 Apr 2023 17:29:42 GMT</pubDate>
    <dc:creator>Bud</dc:creator>
    <dc:date>2023-04-12T17:29:42Z</dc:date>
    <item>
      <title>Clarify the docs: Create Database View can be used to replace an existing view</title>
      <link>https://community.esri.com/t5/arcgis-pro-ideas/clarify-the-docs-create-database-view-can-be-used/idi-p/1277914</link>
      <description>&lt;P&gt;&lt;EM&gt;ArcGIS Pro 3.1.1&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;It looks like the&amp;nbsp;Create Database View geoprocessing tool can be used to &lt;U&gt;&lt;EM&gt;replace&lt;/EM&gt;&lt;/U&gt; a view, not just create a new view.&amp;nbsp;Just use the same name as an existing view: &lt;A href="https://community.esri.com/t5/data-management-ideas/database-views-edit-sql-definition-in-catalog/idc-p/1277895" target="_self"&gt;Idea - Database Views: Edit SQL definition in Catalog&lt;/A&gt;.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_0-1681320404273.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/67790iFAF3863D45F773A2/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Bud_0-1681320404273.png" alt="Bud_0-1681320404273.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You'd never know it's possible to replace a view with that tool from reading the docs:&lt;/P&gt;&lt;BLOCKQUOTE&gt;&lt;P&gt;&lt;A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-view.htm" target="_self"&gt;Create Database View (Data Management)&lt;/A&gt;&lt;/P&gt;&lt;P&gt;Creates a view in a database based on an SQL expression.&lt;/P&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;Could the documentation be improved so that it informs users that creating a database view using the same name as an existing view will replace the view?&lt;BR /&gt;Note: Could&amp;nbsp;&lt;SPAN&gt;it be made clear whether the tool &lt;U&gt;&lt;EM&gt;modifies&lt;/EM&gt;&lt;/U&gt; the existing view or just &lt;U&gt;&lt;EM&gt;deletes&lt;/EM&gt;&lt;/U&gt; it and creates a &lt;U&gt;&lt;EM&gt;new&lt;/EM&gt;&lt;/U&gt; one? For example, in an enterprise geodatabase view, would the privileges that were set up in the view be preserved? Or would they be lost because the view was deleted and recreated?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;Also, should the name of the tool be changed to "Create &lt;STRONG&gt;or Replace&lt;/STRONG&gt; Database View"?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 12 Apr 2023 17:29:42 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-pro-ideas/clarify-the-docs-create-database-view-can-be-used/idi-p/1277914</guid>
      <dc:creator>Bud</dc:creator>
      <dc:date>2023-04-12T17:29:42Z</dc:date>
    </item>
    <item>
      <title>Re: Clarify the docs: Create Database View can be used to replace an existing view - Status changed to: Closed</title>
      <link>https://community.esri.com/t5/arcgis-pro-ideas/clarify-the-docs-create-database-view-can-be-used/idc-p/1277967#M24418</link>
      <description>&lt;P&gt;&lt;a href="https://community.esri.com/t5/user/viewprofilepage/user-id/351335"&gt;@Bud&lt;/a&gt;&amp;nbsp; Any geoprocessing tool can replace an existing output as long as you have the the option to allow GP tools to overwrite existing outputs clicked on in the options menu.&amp;nbsp;&lt;/P&gt;&lt;P&gt;For feedback on documentation, we recommend users click the 'Feedback on this topic?' link at the bottom of any of our help documents.&amp;nbsp; This will get sent to the correct person for review and action and the team can act accordingly.&amp;nbsp;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 12 Apr 2023 19:32:30 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-pro-ideas/clarify-the-docs-create-database-view-can-be-used/idc-p/1277967#M24418</guid>
      <dc:creator>SSWoodward</dc:creator>
      <dc:date>2023-04-12T19:32:30Z</dc:date>
    </item>
  </channel>
</rss>

