topic Re: How to delete feature dataset and feature class SDE ? in ArcObjects SDK Questions

How to delete feature dataset and feature class SDE ?

TaiBui — Tue, 25 Feb 2014 12:57:58 GMT

Hi everyone,

Are there anyone know the statements/methods to delete a SDE feature dataset and a SDE feature class from SDE database ? (using C# or VB)

Thank you very much.

Tai

Re: How to delete feature dataset and feature class SDE ?

NeilClemmons — Tue, 25 Feb 2014 13:18:05 GMT

Use IDataset.Delete. I would imagine you can't delete feature datasets unless they are empty though.

Re: How to delete feature dataset and feature class SDE ?

TaiBui — Sat, 11 Dec 2021 16:20:42 GMT

Use IDataset.Delete. I would imagine you can't delete feature datasets unless they are empty though.

Thanks Neil,

I got the error: Layer in use SDE when trying to delete.

Please see my code:

                        IDataset pdataset;
                        pdataset = (ESRI.ArcGIS.Geodatabase.IDataset)featureClass;

                        if (pdataset.CanDelete() && pdataset != null)
                            pdataset.Delete();            // Throw exception

Do you know how to fix this ?

Thanks and regards,

Tai

Re: How to delete feature dataset and feature class SDE ?

NeilClemmons — Wed, 26 Feb 2014 12:15:53 GMT

Where is the feature class in use? If it's in your map document then you probably need to disconnect the layer from its data source (IDataLayer2.Disconnect) and delete it from the map.

Re: How to delete feature dataset and feature class SDE ?

RobertBorchert — Wed, 26 Feb 2014 12:37:21 GMT

Compress your database, you should unregister as versioned those what you wish to delete. compress it again.

shut down all programs accessing the SDE, compress it and try it again. if that does not work go into SQL Server Configuration Manager and restart the service. That will issue a kill command to anything connected.

Where is the feature class in use? If it's in your map document then you probably need to disconnect the layer from its data source (IDataLayer2.Disconnect) and delete it from the map.