deletesaredetected-method-sqlserverdatabasemetadata.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	apilocation	apiname	apitype
deletesAreDetected Method (SQLServerDatabaseMetaData)	deletesAreDetected Method (SQLServerDatabaseMetaData)	David-Engel	davidengel	01/20/2017	sql	connectivity	reference	sqljdbc.jar	SQLServerDatabaseMetaData.deletesAreDetected	Assembly

deletesAreDetected Method (SQLServerDatabaseMetaData)

[!INCLUDEDriver_JDBC_Download]

Retrieves whether or not a visible row delete can be detected by calling the rowDeleted method of the SQLServerResultSet class.

Syntax

public boolean deletesAreDetected(int type)  

Parameters

type

An int that indicates the result set type, which can be one of the following values as defined in java.sql.ResultSet or SQLServerResultSet:

java.sql.ResultSet Types

TYPE_FORWARD_ONLY

TYPE_SCROLL_SENSITIVE

TYPE_SCROLL_INSENSITIVE

SQLServerResultSet Types

TYPE_SS_SCROLL_STATIC

TYPE_SS_SCROLL_KEYSET

TYPE_SS_DIRECT_FORWARD_ONLY

TYPE_SS_SERVER_CURSOR_FORWARD_ONLY

TYPE_SS_SCROLL_DYNAMIC

Return Value

true if a gap replaces the deleted row. false if the deleted row is removed.

When using the [!INCLUDEjdbcNoVersion] with a [!INCLUDEssNoVersion] database, this method returns true for TYPE_SS_SCROLL_KEYSET cursors and false for all other result set types.

Exceptions

SQLServerException

Remarks

This deletesAreDetected method is specified by the deletesAreDetected method in the java.sql.DatabaseMetaData interface.

Note

[!INCLUDEssNoVersion] detects deleted rows for all updatable cursor types, although the detection is transient for forward and dynamic cursors.

See Also

SQLServerDatabaseMetaData Methods
SQLServerDatabaseMetaData Members
SQLServerDatabaseMetaData Class