How to completely delete a feature class in SQL server?

Question

Dear All,

Just curious to know how to completely delete a feature class (not involved in topologoy and relationship) in SQL server. I tried to delete the business table, the record in SDE_table_registery, and the record in SDE_Layers. But still gave me an error (table already exists...) when I tried to create a feature class with the same name via ArcCatalog.

What tables else should I delete? Thanks for the help,

Russel

VinceAngelo · Answer

The tables only need entries in the geodatabase metadata tables to
prevent recreation.  The easiest workaround is to create an empty
table with the same name via SQL, then use Catalog to delete it over
again.  If that doesn't do the trick, contact Tech Support, and let them
walk you through the other procedures.
 
- V

Anonymous User · Answer

I routinely delete feature classes from SDE then replace them with current feature classes. (All in Arc Catalog) It did not work for me tonight. The old feature classes are gone, but when pasting the new ones into the correct dataset I am told that the feature already exists and that I cannot duplicate. 1.) If it is there, where is it and why can't I see it? 2.) How can I get the new features loaded into the SDE dataset?

Thank you,

ducksunlimited · Answer

(look at the entity-relationship diagram and you'll see what I mean).

where to get the entity-relationship diagram?