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"?