https://community.esri.com/t5/geodatabase-questions/is-it-possible-to-create-a-database-view-on-an/m-p/1219135#M7927 <P>I have a need to filter some annotation from related tables.&nbsp; I would like to left outer join an annotation feature class to a different featureclass, add a where clause and keep only the fields from the original annotation feature class and register it with geodatabase as an annotation featureclass.&nbsp; &nbsp;When I do so, it reads the shape as polygon and registers it as a polygon feature class.&nbsp; I would like to keep the annotation class extension on the feature class.&nbsp; Is there a trick to doing this?&nbsp; Like some SDE table to update or a field to add.</P> Wed, 05 Oct 2022 21:19:48 GMT AlexanderGray 2022-10-05T21:19:48Z https://community.esri.com/t5/geodatabase-questions/is-it-possible-to-create-a-database-view-on-an/m-p/1219135#M7927 <P>I have a need to filter some annotation from related tables.&nbsp; I would like to left outer join an annotation feature class to a different featureclass, add a where clause and keep only the fields from the original annotation feature class and register it with geodatabase as an annotation featureclass.&nbsp; &nbsp;When I do so, it reads the shape as polygon and registers it as a polygon feature class.&nbsp; I would like to keep the annotation class extension on the feature class.&nbsp; Is there a trick to doing this?&nbsp; Like some SDE table to update or a field to add.</P> Wed, 05 Oct 2022 21:19:48 GMT https://community.esri.com/t5/geodatabase-questions/is-it-possible-to-create-a-database-view-on-an/m-p/1219135#M7927 AlexanderGray 2022-10-05T21:19:48Z https://community.esri.com/t5/geodatabase-questions/is-it-possible-to-create-a-database-view-on-an/m-p/1225224#M7968 <P>I was taught that annotation is a non-simple polygon, because there are points for stuff like text anchors, rules, the polygon for the extent of the label, and more, stored in each record. So, I think you need some other way to do this.</P> Tue, 25 Oct 2022 15:41:34 GMT https://community.esri.com/t5/geodatabase-questions/is-it-possible-to-create-a-database-view-on-an/m-p/1225224#M7968 DanaNolan 2022-10-25T15:41:34Z