The IsDeleted property indicates whether the referenced object has been deleted from an instance of Microsoft® SQL Server™.
Syntax
object.IsDeleted
object
Expression that evaluates to an object in the Applies To list
value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetIsDeleted(LPBOOL pRetVal);
Remarks
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.