AnsweredAssumed Answered

Once a Database View is created in ArcGIS Pro, how can I go back in and see the SQL that was used?

Question asked by tsellekaerts on Apr 22, 2020
Latest reply on Apr 30, 2020 by bharold-esristaff

I've successfully created a database view using ArcGIS Pro, using arcpy.CreateDatabaseView_management().  Now, I would like to see the SQL that was used in the creation of that view.  I could do this in ArcCatalog by right clicking on the view, Properties, Definition tab.  Is there a way to do this in ArcGIS Pro?  I tried both right click, properties and arcpy.Describe().  Since I still have ArcCatalog I've resorted to using that to view the SQL used to create the view, but am hoping I've just missed something in ArcGIS Pro.

 

Using:

ArcGIS Pro 2.4

ArcCatalog 10.7.1

Outcomes