Table created in SQL, registered with geodatabase shows no records in ArcGIS but is populated in SQL

MeganJohnson

Non spatial table created in SQL to be updated automatically daily. Table will be involved in a join so it is registered with the geodatabase in ArcCatalog, creating an OID in field called ObjectID. When the program is run in SQL to delete the table and recreate it using the same name, 0 records appear in ArcGIS. But it appears to be populated in SQL.

So my question is: If a table is registered with the geodatabase and then deleted in SQL and a new table is created with the same name (essentially overwriting the existing table), does the new one need to be re-registered with the geodatabase? Why else would the table appear to be empty when viewing in ArcMap?

JoshuaBixby

As you have already found out, your workflow as currently implemented won't work.  If the updates were not very common, you could try truncating the table (instead of deleting it) and using a cursor to repopulate it, but I don't think that will work in this case since you are doing frequent updates.

Is the data completely changing in 24 hours?  What percentage of the table is actually getting updates in a day?  I ask because the general approach you are trying is inefficient if a small percentage of the records get updated in a day.  If there are a large number of updates in a day, then I recommend deleting the table (using ArcGIS because the SDE system tables will get cleaned up) and then re-register the table after it is created again.