Join to feature class error

Question

I'm trying to join a table to a feature class in ArcMap. When using the join function, under joins and relates, an error comes up saying my table is not indexed. When I try to add attribute index to my table I get an error " Underlying DBMS error ODBC Driver 13  SQL server, cannot create index on view because the view is not schema bound". I've tried reformatting my data still no luck. Also tried it in Pro, same errors.  Do I need to register the table with a Geodatabase, maybe more a sqlserver error? It is an active table, would that make any difference? Any help would be great!

Thanks

Kevin

AndresCastillo · Accepted Answer

If you are using a database view, it may not like to participate with geodatabase objects.

You might try to register the view with the geodatabase, starting at 10.5, or ArcGIS Pro.

https://community.esri.com/groups/geodatabase/blog/2016/12/14/new-at-105-registering-a-database-view-with-the-geodatabase