Java.Sql.IDatabaseMetaData.GetBestRowIdentifier Method
Returns a list of a table's optimal set of columns that uniquely identify the rows.

Syntax

[Android.Runtime.Register("getBestRowIdentifier", "(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;IZ)Ljava/sql/ResultSet;", "GetGetBestRowIdentifier_Ljava_lang_String_Ljava_lang_String_Ljava_lang_String_IZHandler:Java.Sql.IDatabaseMetaDataInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public IResultSet GetBestRowIdentifier (string catalog, string schema, string table, int scope, bool nullable)

Parameters

catalog
a catalog name. null is used to imply no narrowing of the search by catalog name. Otherwise, the name must match a catalog name held in the database, with "" used to retrieve those without a catalog name.
schema
a schema name pattern. null is used to imply no narrowing of the search by schema name. Otherwise, the name must match a schema name in the database, with "" used to retrieve those without a schema name.
table
the table name. This must match the name of the table as declared in the database.
scope
the SCOPE of interest, values as defined above.
nullable
true = include columns that are nullable, false = do not include nullable columns.

Returns

Documentation for this section has not yet been entered.

Exceptions

TypeReason
Java.Sql.SQLExceptionif there is a database error.

Remarks

Returns a list of a table's optimal set of columns that uniquely identify the rows. The results are ordered by SCOPE (see below).

The results are returned as a table, with one entry for each column, as follows:

  1. SCOPE - short - the SCOPE of the result, as follows:
    • DatabaseMetaData.bestRowTemporary - the result is very temporary, only valid while on the current row
    • DatabaseMetaData.bestRowTransaction - the result is good for remainder of current transaction
    • DatabaseMetaData.bestRowSession - the result is good for remainder of database session
    • COLUMN_NAME - String - the column name
    • DATA_TYPE - int - the Type of the data, as defined in java.sql.Types
    • TYPE_NAME - String - the Name of the type - database dependent. For UDT types the name is fully qualified
    • COLUMN_SIZE - int - the precision of the data in the column
    • BUFFER_LENGTH - int - not used
    • DECIMAL_DIGITS - short - number of fractional digits
    • PSEUDO_COLUMN - short - whether this is a pseudo column (e.g. an Oracle ROWID):
      • DatabaseMetaData.bestRowUnknown - it is not known whether this is a pseudo column
      • DatabaseMetaData.bestRowNotPseudo - the column is not pseudo
      • DatabaseMetaData.bestRowPseudo - the column is a pseudo column

      [Android Documentation]

      Requirements

      Namespace: Java.Sql
      Assembly: Mono.Android (in Mono.Android.dll)
      Assembly Versions: 0.0.0.0
      Since: Added in API level 1