Top Description Constructors Methods
org.h2.jdbc.meta

public abstract Class DatabaseMeta

extends Object
Class Inheritance
Known Direct Subclasses
org.h2.jdbc.meta.DatabaseMetaLocalBase, org.h2.jdbc.meta.DatabaseMetaRemote
Imports
org.h2.mode.DefaultNullOrdering, org.h2.result.ResultInterface

Database meta information.

Constructor Summary

AccessConstructor and Description
public

Method Summary

Modifier and TypeMethod and Description
public abstract DefaultNullOrdering

Returns:

DefaultNullOrdering
defaultNullOrdering
()

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getAttributes
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
"LIKE" style pattern to filter result
typeNamePattern
,
String
"LIKE" style pattern to filter result
attributeNamePattern
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getBestRowIdentifier
(String
"LIKE" style pattern to filter result
catalogPattern
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
table of interest
tableName
,
int
of interest
scope
,
boolean
include nullable columns
nullable
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getCatalogs
()

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getColumnPrivileges
(String
to inspect
catalog
,
String
to inspect
schema
,
String
to inspect
table
,
String
"LIKE" style pattern to filter result
columnNamePattern
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getColumns
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
"LIKE" style pattern to filter result
tableNamePattern
,
String
"LIKE" style pattern to filter result
columnNamePattern
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getCrossReference
(String
to inspect
primaryCatalog
,
String
to inspect
primarySchema
,
String
to inspect
primaryTable
,
String
to inspect
foreignCatalog
,
String
to inspect
foreignSchema
,
String
to inspect
foreignTable
)

INTERNAL

public abstract int

Returns:

ResultInterface
getDatabaseMajorVersion
()

INTERNAL

public abstract int

Returns:

ResultInterface
getDatabaseMinorVersion
()

INTERNAL

public abstract String

Returns:

product version as String
getDatabaseProductVersion
()

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getExportedKeys
(String
to inspect
catalog
,
String
to inspect
schema
,
String
to inspect
table
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getFunctionColumns
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
"LIKE" style pattern to filter result
functionNamePattern
,
String
"LIKE" style pattern to filter result
columnNamePattern
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getFunctions
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
"LIKE" style pattern to filter result
functionNamePattern
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getImportedKeys
(String
to inspect
catalog
,
String
to inspect
schema
,
String
to inspect
table
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getIndexInfo
(String
to inspect
catalog
,
String
to inspect
schema
,
String
to inspect
table
,
boolean
only
unique
,
boolean
allowed
approximate
)

INTERNAL

public abstract String

Returns:

list of supported numeric functions
getNumericFunctions
()

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getPrimaryKeys
(String
to inspect
catalog
,
String
to inspect
schema
,
String
to inspect
table
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getProcedureColumns
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
"LIKE" style pattern to filter result
procedureNamePattern
,
String
"LIKE" style pattern to filter result
columnNamePattern
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getProcedures
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
"LIKE" style pattern to filter result
procedureNamePattern
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getPseudoColumns
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
"LIKE" style pattern to filter result
tableNamePattern
,
String
"LIKE" style pattern to filter result
columnNamePattern
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getSchemas
()

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getSchemas
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
)

INTERNAL

public abstract String

Returns:

search string escape sequence
getSearchStringEscape
()

INTERNAL

public abstract String

Returns:

list of supported SQL keywords
getSQLKeywords
()

INTERNAL

public abstract String

Returns:

list of supported string functions
getStringFunctions
()

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getSuperTables
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
"LIKE" style pattern to filter result
tableNamePattern
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getSuperTypes
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
"LIKE" style pattern to filter result
typeNamePattern
)

INTERNAL

public abstract String

Returns:

list of supported system functions
getSystemFunctions
()

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getTablePrivileges
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
"LIKE" style pattern to filter result
tableNamePattern
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getTables
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
"LIKE" style pattern to filter result
tableNamePattern
,
String[]
String[]
types
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getTableTypes
()

INTERNAL

public abstract String

Returns:

list of supported time/date functions
getTimeDateFunctions
()

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getTypeInfo
()

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getUDTs
(String
to inspect
catalog
,
String
"LIKE" style pattern to filter result
schemaPattern
,
String
"LIKE" style pattern to filter result
typeNamePattern
,
int[]
int[]
types
)

INTERNAL

public abstract ResultInterface

Returns:

ResultInterface
getVersionColumns
(String
to inspect
catalog
,
String
to inspect
schema
,
String
to inspect
table
)

INTERNAL

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Constructor Detail

DatabaseMetaback to summary
public DatabaseMeta()

Method Detail

defaultNullOrderingback to summary
public abstract DefaultNullOrdering defaultNullOrdering()

INTERNAL

Returns:DefaultNullOrdering

DefaultNullOrdering

See Also
java.sql.DatabaseMetaData#nullsAreSortedHigh(), java.sql.DatabaseMetaData#nullsAreSortedLow(), java.sql.DatabaseMetaData#nullsAreSortedAtStart(), java.sql.DatabaseMetaData#nullsAreSortedAtEnd()
getAttributesback to summary
public abstract ResultInterface getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

typeNamePattern:String

"LIKE" style pattern to filter result

attributeNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getAttributes(String, String, String, String)
getBestRowIdentifierback to summary
public abstract ResultInterface getBestRowIdentifier(String catalogPattern, String schemaPattern, String tableName, int scope, boolean nullable)

INTERNAL

Parameters
catalogPattern:String

"LIKE" style pattern to filter result

schemaPattern:String

"LIKE" style pattern to filter result

tableName:String

table of interest

scope:int

of interest

nullable:boolean

include nullable columns

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getBestRowIdentifier(String, String, String, int, boolean)
getCatalogsback to summary
public abstract ResultInterface getCatalogs()

INTERNAL

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getCatalogs()
getColumnPrivilegesback to summary
public abstract ResultInterface getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)

INTERNAL

Parameters
catalog:String

to inspect

schema:String

to inspect

table:String

to inspect

columnNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getColumnPrivileges(String, String, String, String)
getColumnsback to summary
public abstract ResultInterface getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

tableNamePattern:String

"LIKE" style pattern to filter result

columnNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getColumns(String, String, String, String)
getCrossReferenceback to summary
public abstract ResultInterface getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)

INTERNAL

Parameters
primaryCatalog:String

to inspect

primarySchema:String

to inspect

primaryTable:String

to inspect

foreignCatalog:String

to inspect

foreignSchema:String

to inspect

foreignTable:String

to inspect

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getCrossReference(String, String, String, String, String, String)
getDatabaseMajorVersionback to summary
public abstract int getDatabaseMajorVersion()

INTERNAL

Returns:int

ResultInterface

See Also
java.sql.DatabaseMetaData#getDatabaseMajorVersion()
getDatabaseMinorVersionback to summary
public abstract int getDatabaseMinorVersion()

INTERNAL

Returns:int

ResultInterface

See Also
java.sql.DatabaseMetaData#getDatabaseMinorVersion()
getDatabaseProductVersionback to summary
public abstract String getDatabaseProductVersion()

INTERNAL

Returns:String

product version as String

See Also
java.sql.DatabaseMetaData#getDatabaseProductVersion()
getExportedKeysback to summary
public abstract ResultInterface getExportedKeys(String catalog, String schema, String table)

INTERNAL

Parameters
catalog:String

to inspect

schema:String

to inspect

table:String

to inspect

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getExportedKeys(String, String, String)
getFunctionColumnsback to summary
public abstract ResultInterface getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

functionNamePattern:String

"LIKE" style pattern to filter result

columnNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getFunctionColumns(String, String, String, String)
getFunctionsback to summary
public abstract ResultInterface getFunctions(String catalog, String schemaPattern, String functionNamePattern)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

functionNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getFunctions(String, String, String)
getImportedKeysback to summary
public abstract ResultInterface getImportedKeys(String catalog, String schema, String table)

INTERNAL

Parameters
catalog:String

to inspect

schema:String

to inspect

table:String

to inspect

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getImportedKeys(String, String, String)
getIndexInfoback to summary
public abstract ResultInterface getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)

INTERNAL

Parameters
catalog:String

to inspect

schema:String

to inspect

table:String

to inspect

unique:boolean

only

approximate:boolean

allowed

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getIndexInfo(String, String, String, boolean, boolean)
getNumericFunctionsback to summary
public abstract String getNumericFunctions()

INTERNAL

Returns:String

list of supported numeric functions

See Also
java.sql.DatabaseMetaData#getNumericFunctions()
getPrimaryKeysback to summary
public abstract ResultInterface getPrimaryKeys(String catalog, String schema, String table)

INTERNAL

Parameters
catalog:String

to inspect

schema:String

to inspect

table:String

to inspect

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getPrimaryKeys(String, String, String)
getProcedureColumnsback to summary
public abstract ResultInterface getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

procedureNamePattern:String

"LIKE" style pattern to filter result

columnNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getProcedureColumns(String, String, String, String)
getProceduresback to summary
public abstract ResultInterface getProcedures(String catalog, String schemaPattern, String procedureNamePattern)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

procedureNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getProcedures(String, String, String)
getPseudoColumnsback to summary
public abstract ResultInterface getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

tableNamePattern:String

"LIKE" style pattern to filter result

columnNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getPseudoColumns(String, String, String, String)
getSchemasback to summary
public abstract ResultInterface getSchemas()

INTERNAL

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getSchemas()
getSchemasback to summary
public abstract ResultInterface getSchemas(String catalog, String schemaPattern)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getSchemas(String, String)
getSearchStringEscapeback to summary
public abstract String getSearchStringEscape()

INTERNAL

Returns:String

search string escape sequence

See Also
java.sql.DatabaseMetaData#getSearchStringEscape()
getSQLKeywordsback to summary
public abstract String getSQLKeywords()

INTERNAL

Returns:String

list of supported SQL keywords

See Also
java.sql.DatabaseMetaData#getSQLKeywords()
getStringFunctionsback to summary
public abstract String getStringFunctions()

INTERNAL

Returns:String

list of supported string functions

See Also
java.sql.DatabaseMetaData#getStringFunctions()
getSuperTablesback to summary
public abstract ResultInterface getSuperTables(String catalog, String schemaPattern, String tableNamePattern)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

tableNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getSuperTables(String, String, String)
getSuperTypesback to summary
public abstract ResultInterface getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

typeNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getSuperTypes(String, String, String)
getSystemFunctionsback to summary
public abstract String getSystemFunctions()

INTERNAL

Returns:String

list of supported system functions

See Also
java.sql.DatabaseMetaData#getSystemFunctions()
getTablePrivilegesback to summary
public abstract ResultInterface getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

tableNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getTablePrivileges(String, String, String)
getTablesback to summary
public abstract ResultInterface getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

tableNamePattern:String

"LIKE" style pattern to filter result

types:String[]

String[]

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getTables(String, String, String, String[])
getTableTypesback to summary
public abstract ResultInterface getTableTypes()

INTERNAL

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getTableTypes()
getTimeDateFunctionsback to summary
public abstract String getTimeDateFunctions()

INTERNAL

Returns:String

list of supported time/date functions

See Also
java.sql.DatabaseMetaData#getTimeDateFunctions()
getTypeInfoback to summary
public abstract ResultInterface getTypeInfo()

INTERNAL

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getTypeInfo()
getUDTsback to summary
public abstract ResultInterface getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

typeNamePattern:String

"LIKE" style pattern to filter result

types:int[]

int[]

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getUDTs(String, String, String, int[])
getVersionColumnsback to summary
public abstract ResultInterface getVersionColumns(String catalog, String schema, String table)

INTERNAL

Parameters
catalog:String

to inspect

schema:String

to inspect

table:String

to inspect

Returns:ResultInterface

ResultInterface

See Also
java.sql.DatabaseMetaData#getVersionColumns(String, String, String)