topic Behavior of Views Created by Create Database View GP Tool in 10.1 in Data Management Questions https://community.esri.com/t5/data-management-questions/behavior-of-views-created-by-create-database-view/m-p/517976#M29372 <HTML><HEAD></HEAD><BODY><SPAN>I wrote a Python script with ArcGIS 10.1 that runs the "Create Database View" GP tool to make views for all of an ArcSDE geodatabase's featureclasses and non-spatial tables.</SPAN><BR /><BR /><SPAN>The views appear to be created okay (using SELECT * FROM &lt;TABLE&gt;).&nbsp; However....&nbsp;&nbsp; for some of the views, ...only some..., ArcCatalog previews the geography but returns an error message when previewing the table.&nbsp; It returns a vague message (about assuring you have an OID) instead of showing the table.</SPAN><BR /><BR /><SPAN>When any of the views (whether or not the table previews in ArcCatalog) is added to ArcMap, ArcMap treats the view as a Query Layer and prompts for the unique ID field.</SPAN><BR /><BR /><SPAN>Why might only some views of featureclasses not show their tables in ArcCatalog?&nbsp; Am I missing something?&nbsp; Should these views be used as Query Layers?&nbsp; Is there something that I need to do in order to cause the views to behave the same way as their underlying featureclasses?</SPAN></BODY></HTML> Wed, 23 Jan 2013 23:56:15 GMT IvanBrown 2013-01-23T23:56:15Z Behavior of Views Created by Create Database View GP Tool in 10.1 https://community.esri.com/t5/data-management-questions/behavior-of-views-created-by-create-database-view/m-p/517976#M29372 <HTML><HEAD></HEAD><BODY><SPAN>I wrote a Python script with ArcGIS 10.1 that runs the "Create Database View" GP tool to make views for all of an ArcSDE geodatabase's featureclasses and non-spatial tables.</SPAN><BR /><BR /><SPAN>The views appear to be created okay (using SELECT * FROM &lt;TABLE&gt;).&nbsp; However....&nbsp;&nbsp; for some of the views, ...only some..., ArcCatalog previews the geography but returns an error message when previewing the table.&nbsp; It returns a vague message (about assuring you have an OID) instead of showing the table.</SPAN><BR /><BR /><SPAN>When any of the views (whether or not the table previews in ArcCatalog) is added to ArcMap, ArcMap treats the view as a Query Layer and prompts for the unique ID field.</SPAN><BR /><BR /><SPAN>Why might only some views of featureclasses not show their tables in ArcCatalog?&nbsp; Am I missing something?&nbsp; Should these views be used as Query Layers?&nbsp; Is there something that I need to do in order to cause the views to behave the same way as their underlying featureclasses?</SPAN></BODY></HTML> Wed, 23 Jan 2013 23:56:15 GMT https://community.esri.com/t5/data-management-questions/behavior-of-views-created-by-create-database-view/m-p/517976#M29372 IvanBrown 2013-01-23T23:56:15Z