ArcGIS Pro 3.1.1
It looks like the Create Database View geoprocessing tool can be used to replace a view, not just create a new view. Just use the same name as an existing view: Idea - Database Views: Edit SQL definition in Catalog.
You'd never know it's possible to replace a view with that tool from reading the docs:
Create Database View (Data Management)
Creates a view in a database based on an SQL expression.
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?
Note: Could it be made clear whether the tool modifies the existing view or just deletes it and creates a new 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?
Also, should the name of the tool be changed to "Create or Replace Database View"?
@Bud 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.
For feedback on documentation, we recommend users click the 'Feedback on this topic?' link at the bottom of any of our help documents. This will get sent to the correct person for review and action and the team can act accordingly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.