IDatabaseMetaData.GetTables(String, String, String, String[]) Method

Reference

Definition

Namespace:: Java.Sql

Assembly:: Mono.Android.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Retrieves a description of the tables available in the given catalog.

[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 Java.Sql.IResultSet? GetTables (string? catalog, string? schemaPattern, string? tableNamePattern, string[]? types);

[<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")>]
abstract member GetTables : string * string * string * string[] -> Java.Sql.IResultSet

Parameters

catalog: String

a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search

schemaPattern: String

a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search

tableNamePattern: String

a table name pattern; must match the table name as it is stored in the database

types: String[]

a list of table types, which must be from the list of table types returned from #getTableTypes,to include; null returns all types

Returns

IResultSet

ResultSet - each row is a table description

Attributes: RegisterAttribute

Exceptions

SQLException

a database error occurred.

Remarks

Retrieves a description of the tables available in the given catalog. Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_CAT, TABLE_SCHEM and TABLE_NAME.

Each table description has the following columns: <OL> <LI>TABLE_CAT String => table catalog (may be null) <LI>TABLE_SCHEM String => table schema (may be null) <LI>TABLE_NAME String => table name <LI>TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM". <LI>REMARKS String => explanatory comment on the table <LI>TYPE_CAT String => the types catalog (may be null) <LI>TYPE_SCHEM String => the types schema (may be null) <LI>TYPE_NAME String => type name (may be null) <LI>SELF_REFERENCING_COL_NAME String => name of the designated "identifier" column of a typed table (may be null) <LI>REF_GENERATION String => specifies how values in SELF_REFERENCING_COL_NAME are created. Values are "SYSTEM", "USER", "DERIVED". (may be null) </OL>

Note: Some databases may not return information for all tables.

Java documentation for java.sql.DatabaseMetaData.getTables(java.lang.String, java.lang.String, java.lang.String, java.lang.String[]).

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

Applies to