Compartir a través de


IsDeleted Property

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

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

Sintaxis

object
.IsDeleted

Parts

  • object
    An expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetIsDeleted(LPBOOL pRetVal);

Notas

If a client session creates an object using SQL Distributed Management Objects (SQL-DMO), and another client session subsequently deletes the object using another tool, 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 CustReportTable 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 SQL Server and then refreshes the entire collection of objects.

IsDeleted returns TRUE if 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.

[!NOTA] IsDeleted can be used with SQL Server 2005, SQL Server 2000, and SQL Server version 7.0.

Applies To:

Database2 Object

Table2 Object

DatabaseRole2 Object

Trigger2 Object

Default2 Object

User2 Object

Login2 Object

UserDefinedDataType2 Object

Rule2 Object

UserDefinedFunction Object

StoredProcedure2 Object

View2 Object

Vea también

Referencia

IsObjectDeleted Method

Ayuda e información

Obtener ayuda sobre SQL Server 2005