Share via


IDatabaseMetaData.GetSuperTables(String, String, String) Method

Definition

Retrieves a description of the table hierarchies defined in a particular schema in this database.

[Android.Runtime.Register("getSuperTables", "(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;", "GetGetSuperTables_Ljava_lang_String_Ljava_lang_String_Ljava_lang_String_Handler:Java.Sql.IDatabaseMetaDataInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public Java.Sql.IResultSet? GetSuperTables (string? catalog, string? schemaPattern, string? tableNamePattern);
[<Android.Runtime.Register("getSuperTables", "(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;", "GetGetSuperTables_Ljava_lang_String_Ljava_lang_String_Ljava_lang_String_Handler:Java.Sql.IDatabaseMetaDataInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member GetSuperTables : string * string * string -> Java.Sql.IResultSet

Parameters

catalog
String

a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria

schemaPattern
String

a schema name pattern; "" retrieves those without a schema

tableNamePattern
String

a table name pattern; may be a fully-qualified name

Returns

a ResultSet object in which each row is a type description

Attributes

Exceptions

a database error occurred.

Remarks

Retrieves a description of the table hierarchies defined in a particular schema in this database.

Only supertable information for tables matching the catalog, schema and table name are returned. The table name parameter may be a fully- qualified name, in which case, the catalog and schemaPattern parameters are ignored. If a table does not have a super table, it is not listed here. Supertables have to be defined in the same catalog and schema as the sub tables. Therefore, the type description does not need to include this information for the supertable.

Each type description has the following columns: <OL> <LI><B>TABLE_CAT</B> String => the type's catalog (may be null) <LI><B>TABLE_SCHEM</B> String => type's schema (may be null) <LI><B>TABLE_NAME</B> String => type name <LI><B>SUPERTABLE_NAME</B> String => the direct super type's name </OL>

<B>Note:</B> If the driver does not support type hierarchies, an empty result set is returned.

Added in 1.4.

Java documentation for java.sql.DatabaseMetaData.getSuperTables(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