AnsweredAssumed Answered

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

Question asked by mjohnson278 on Jun 29, 2017
Latest reply on Jul 3, 2017 by bixb0012

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?

Outcomes