Add and Delete Tables in SQL Server Manager

Looking at Add & Delete Tables in SQL Server

Start, Run, mstsc

Connect to Trapper, key in password

Open to click on SQL Server Manager Studio (in bottom tray)

Connect

Databases

Find your particular database, such as OTHER CVT

Scroll down to Tables

Find SDE Table Registry (may have a .dbo in front of it)

Right click on table registry, Select all rows

In the top right box, after the last text, type

Order by [table_name] (as you start to type “tabl…” you should see the list of options, when you see table_name, hit Tab on keyboard and it will insert the name for you)

Click on Execute button (near top)

Now your tables are in name order

Find your particular table name, such as RochesterParcelAttribute

Look at the reg_ID number (first field).  This is that particular table’s number (222)

Look in tree on left, find RHC.a222 (this is the add table)

Right click on RHC.a222, Select all rows, if there are records in this table, they are edits that are waiting to be added.

Look in tree on left, find RHC.d222 (this is the delete table)

Right click on RHC.d222, Select all rows, if there are records in this table, they are edits that are waiting to be deleted

Note:  SDE is the software/technology that connects SQL Server Manager with ArcGIS.  SDE will be going away with ArcMap version 10.3