Community
Select to view content in your preferred language

SQL Server and Tables

660
1
05-13-2012 03:59 PM
BenjaminFoster
by
New Contributor
‎05-13-2012 03:59 PM
I'm using ArcGIS 10 Desktop with a connection to a local SQL Server (2008) instance.  I've created my gdb on the server instance (with ArcCatalog) and have added a couple of features.  When I go to Management Studio to see if I can view my edits in the table there, there are no records.  The table's there and there are field headings, but no rows.  I expected to see the data I had placed in ArcMap, i.e., a populated table. 

I want to see a populated table now because later I'll be writing some queries and creating views that I'll want to see again in ArcMap, but if there's nothing to populate the query then that will be a wash. 

Why won't the table populate in the SQL Server (Mgmt. Studio & Query views) view?  Please let me know what other info you may need in order to help me out.  Thanks,
0 Kudos
1 Reply
by Anonymous User
Not applicable
‎05-14-2012 08:17 AM
If the data you are editting is registered as versioned, then the edits will actually be in associated delta tables.  These tables will be named A<RegID> and D<RegID>.  The RegID is the registration_id value for this particular SDE Table or Layer as listed in the SDE_TABLE_REGISTRY table.

If these objects are versioned and you need to write SQL to access the data, you will need to look into multi-versioned views.

If you are working with simple feature classes, you may not require versioning to be enabled.  If so, you may find it easier to work with non-versioned data.  If the data isn't versoined then the edits will go directly into the base table (the table with the same name as your layer).

John O
0 Kudos