Java.Sql.IDatabaseMetaData.GetTables Method
Returns a description of the tables in a specified catalog.

Syntax

[Android.Runtime.Register("getTables", "(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Ljava/sql/ResultSet;", "GetGetTables_Ljava_lang_String_Ljava_lang_String_Ljava_lang_String_arrayLjava_lang_String_Handler:Java.Sql.IDatabaseMetaDataInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public IResultSet GetTables (string catalog, string schemaPattern, string tableNamePattern, string[] types)

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.
schemaPattern
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.
tableNamePattern
a table name, which should match the table name as stored in the database.
types
a list of table types to include in the list. null implies list all types.

Returns

Documentation for this section has not yet been entered.

Exceptions

TypeReason
Java.Sql.SQLExceptiona database error occurred.

Remarks

Returns a description of the tables in a specified catalog.

The descriptions are returned as rows in a ResultSet, one row for each Table. The ResultSet is ordered by TABLE_TYPE, TABLE_SCHEM and TABLE_NAME. Each row in the ResultSet consists of a series of columns as follows:

  1. TABLE_CAT - String - table catalog name (possibly null)
  2. TABLE_SCHEM - String - Table schema name (possibly null)
  3. TABLE_NAME - String - The table name
  4. TABLE_TYPE - String - Typical names include "TABLE", "VIEW", "SYSTEM TABLE", "ALIAS", "SYNONYM", "GLOBAL TEMPORARY"
  5. REMARKS - String - A comment describing the table
  6. TYPE_CAT - String - the 'Types' catalog(possibly null )
  7. TYPE_SCHEM - String - the 'Types' schema(possibly null)
  8. TYPE_NAME - String - the 'Types' name (possibly null)
  9. SELF_REFERENCING_COL_NAME - String - the name of a designated identifier column in a typed table (possibly null)
  10. REF_GENERATION - String - one of the following values : "SYSTEM" | "USER" | "DERIVED" - specifies how values in the SELF_REFERENCING_COL_NAME are created (possibly null)

[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