https://community.esri.com/t5/arcgis-pro-ideas/sample-script-to-unregister-database-view-with/idi-p/1569892 <P>Making a SQL change to a registered database view (FGDB, mobile geodatabase, or EGDB) is an inefficient process. We don't have a GP or UI tool to unregister the view with the geodatabase, so instead we need to delete the existing view, recreate it, register it with the geodatabase, and then set up all the DB privileges again.</P><P>It would be great if Esri could provide a sample python script that would unregister the view with the geodatabase. (If Pro is capable of unregistering when deleting a view, then why can't it unregister <U><EM>without</EM></U> deleting the underlying DB view?)</P><P>I figure, if Esri was going to provide a GP tool to unregister views, they would have done it by now. So I'm not hopeful that tool will ever be created. As an alternative, I am wondering if it would be easier for the Python team to whip up a sample script.</P> Thu, 19 Dec 2024 15:04:52 GMT Bud 2024-12-19T15:04:52Z https://community.esri.com/t5/arcgis-pro-ideas/sample-script-to-unregister-database-view-with/idi-p/1569892 <P>Making a SQL change to a registered database view (FGDB, mobile geodatabase, or EGDB) is an inefficient process. We don't have a GP or UI tool to unregister the view with the geodatabase, so instead we need to delete the existing view, recreate it, register it with the geodatabase, and then set up all the DB privileges again.</P><P>It would be great if Esri could provide a sample python script that would unregister the view with the geodatabase. (If Pro is capable of unregistering when deleting a view, then why can't it unregister <U><EM>without</EM></U> deleting the underlying DB view?)</P><P>I figure, if Esri was going to provide a GP tool to unregister views, they would have done it by now. So I'm not hopeful that tool will ever be created. As an alternative, I am wondering if it would be easier for the Python team to whip up a sample script.</P> Thu, 19 Dec 2024 15:04:52 GMT https://community.esri.com/t5/arcgis-pro-ideas/sample-script-to-unregister-database-view-with/idi-p/1569892 Bud 2024-12-19T15:04:52Z