I've successfully created a spatial view of a feature class stored in one of the project's GDBs. However, this particular feature class has attachments and I don't particularly want to lose that information (in fact, we can't! It's needed for the project). My initial question:
If that's possible, how? I've tried to create a view running the following SQL and the view returns 0 results.
CREATE VIEW BridgeDecks
FROM ProjName_Assets.dbo.ProjName_BRIDGEDECKS_MASTER AS br,
ProjName_Assets.dbo.ProjName_BRIDGEDECKS__ATTACH AS brAtt
WHERE br.OBJECTID = brAtt.REL_OBJECTID
AND br.OBJECTID IS NOT NULL;
Any pointers would be just wonderful! Some notes for clarification...
ProjName_BridgeDecks_Master is the feature class
ProjName_BridgeDecks__Attach is the table
ProjName_BridgeDecks__AttachRel is the relationship class that appears in ArcCatalog, though it's not used in this sql
Attachments are enabled on a feature class, but aren't actually stored in the feature class. There is a relationship class to a table, where the attachments for each feature get stored.
I tried to create a view that would preserve attachments (i.e. create a join that adds the BLOB fields from the attachments table to the view), but unfortunately that was not successful. Additionally, it is not possible to create a relationship class from a view to the original attachments table because views aren't registered with the geodatabase
Ultimately, attachments are designed to be enabled on feature classes not views.