The IsDeleted property indicates whether the referenced object has been deleted from an instance of Microsoft® SQL Server™.
|Database2 Object||Table2 Object|
|DatabaseRole2 Object||Trigger2 Object|
|Default2 Object||User2 Object|
|Login2 Object||UserDefinedDataType2 Object|
|Rule2 Object||UserDefinedFunction Object|
|StoredProcedure2 Object||View2 Object|
Expression that evaluates to an object in the Applies To list
TRUE or FALSE
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.