Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
IsDeleted Property

IsDeleted Property

SQL Server 2000

IsDeleted Property

The IsDeleted property indicates whether the referenced object has been deleted from an instance of Microsoft® SQL Server™.

Applies To





Expression that evaluates to an object in the Applies To list



Data Type




Prototype (C/C++)

HRESULT GetIsDeleted(LPBOOL pRetVal);


If a client session creates an object using SQL-DMO, and another client session subsequently deletes the object using another tool (for example, SQL Query Analyzer), the SQL-DMO application is unaware of the deletion. For example, if a SQL-DMO application creates a Tables collection that contains the CustReport table, and another application subsequently deletes the CustReport table, the CustReport table remains in the SQL-DMO internal cache until the SQL-DMO application refreshes the Tables collection by calling the Refresh method. Until the internal cache is refreshed, if the SQL-DMO application calls the properties or methods of the CustReport Table object, SQL-DMO attempts to access the deleted table.

A SQL-DMO application can use the IsDeleted property to verify the existence of the object without calling the Refresh method, which requires a round trip from the computer running the application to the instance of Microsoft® SQL Server™, and then refreshes the entire collection of objects.

IsDeleted returns TRUE the object has been deleted from the server. However, IsDeleted does not clean up the SQL-DMO internal cache. The application must call the Refresh method to perform the cleanup process.

Note  IsDeleted can be used with SQL Server 2000 and SQL Server version 7.0.

See Also

IsObjectDeleted Method

© 2015 Microsoft