Package org.h2.jdbc.meta
Class DatabaseMeta
java.lang.Object
org.h2.jdbc.meta.DatabaseMeta
- Direct Known Subclasses:
DatabaseMetaLocalBase
,DatabaseMetaRemote
Database meta information.
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionabstract DefaultNullOrdering
INTERNALabstract ResultInterface
getAttributes
(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) INTERNALabstract ResultInterface
getBestRowIdentifier
(String catalogPattern, String schemaPattern, String tableName, int scope, boolean nullable) INTERNALabstract ResultInterface
INTERNALabstract ResultInterface
getColumnPrivileges
(String catalog, String schema, String table, String columnNamePattern) INTERNALabstract ResultInterface
getColumns
(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) INTERNALabstract ResultInterface
getCrossReference
(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) INTERNALabstract int
INTERNALabstract int
INTERNALabstract String
INTERNALabstract ResultInterface
getExportedKeys
(String catalog, String schema, String table) INTERNALabstract ResultInterface
getFunctionColumns
(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) INTERNALabstract ResultInterface
getFunctions
(String catalog, String schemaPattern, String functionNamePattern) INTERNALabstract ResultInterface
getImportedKeys
(String catalog, String schema, String table) INTERNALabstract ResultInterface
getIndexInfo
(String catalog, String schema, String table, boolean unique, boolean approximate) INTERNALabstract String
INTERNALabstract ResultInterface
getPrimaryKeys
(String catalog, String schema, String table) INTERNALabstract ResultInterface
getProcedureColumns
(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) INTERNALabstract ResultInterface
getProcedures
(String catalog, String schemaPattern, String procedureNamePattern) INTERNALabstract ResultInterface
getPseudoColumns
(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) INTERNALabstract ResultInterface
INTERNALabstract ResultInterface
getSchemas
(String catalog, String schemaPattern) INTERNALabstract String
INTERNALabstract String
INTERNALabstract String
INTERNALabstract ResultInterface
getSuperTables
(String catalog, String schemaPattern, String tableNamePattern) INTERNALabstract ResultInterface
getSuperTypes
(String catalog, String schemaPattern, String typeNamePattern) INTERNALabstract String
INTERNALabstract ResultInterface
getTablePrivileges
(String catalog, String schemaPattern, String tableNamePattern) INTERNALabstract ResultInterface
INTERNALabstract ResultInterface
INTERNALabstract String
INTERNALabstract ResultInterface
INTERNALabstract ResultInterface
INTERNALabstract ResultInterface
getVersionColumns
(String catalog, String schema, String table) INTERNAL
-
Constructor Details
-
DatabaseMeta
public DatabaseMeta()
-
-
Method Details
-
defaultNullOrdering
INTERNAL- Returns:
- DefaultNullOrdering
- See Also:
-
getDatabaseProductVersion
INTERNAL- Returns:
- product version as String
- See Also:
-
getSQLKeywords
INTERNAL- Returns:
- list of supported SQL keywords
- See Also:
-
getNumericFunctions
INTERNAL- Returns:
- list of supported numeric functions
- See Also:
-
getStringFunctions
INTERNAL- Returns:
- list of supported string functions
- See Also:
-
getSystemFunctions
INTERNAL- Returns:
- list of supported system functions
- See Also:
-
getTimeDateFunctions
INTERNAL- Returns:
- list of supported time/date functions
- See Also:
-
getSearchStringEscape
INTERNAL- Returns:
- search string escape sequence
- See Also:
-
getProcedures
public abstract ResultInterface getProcedures(String catalog, String schemaPattern, String procedureNamePattern) INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter resultprocedureNamePattern
- "LIKE" style pattern to filter result- Returns:
- ResultInterface
- See Also:
-
getProcedureColumns
public abstract ResultInterface getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter resultprocedureNamePattern
- "LIKE" style pattern to filter resultcolumnNamePattern
- "LIKE" style pattern to filter result- Returns:
- ResultInterface
- See Also:
-
getTables
public abstract ResultInterface getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter resulttableNamePattern
- "LIKE" style pattern to filter resulttypes
- String[]- Returns:
- ResultInterface
- See Also:
-
getSchemas
INTERNAL- Returns:
- ResultInterface
- See Also:
-
getCatalogs
INTERNAL- Returns:
- ResultInterface
- See Also:
-
getTableTypes
INTERNAL- Returns:
- ResultInterface
- See Also:
-
getColumns
public abstract ResultInterface getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter resulttableNamePattern
- "LIKE" style pattern to filter resultcolumnNamePattern
- "LIKE" style pattern to filter result- Returns:
- ResultInterface
- See Also:
-
getColumnPrivileges
public abstract ResultInterface getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) INTERNAL- Parameters:
catalog
- to inspectschema
- to inspecttable
- to inspectcolumnNamePattern
- "LIKE" style pattern to filter result- Returns:
- ResultInterface
- See Also:
-
getTablePrivileges
public abstract ResultInterface getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter resulttableNamePattern
- "LIKE" style pattern to filter result- Returns:
- ResultInterface
- See Also:
-
getBestRowIdentifier
public abstract ResultInterface getBestRowIdentifier(String catalogPattern, String schemaPattern, String tableName, int scope, boolean nullable) INTERNAL- Parameters:
catalogPattern
- "LIKE" style pattern to filter resultschemaPattern
- "LIKE" style pattern to filter resulttableName
- table of interestscope
- of interestnullable
- include nullable columns- Returns:
- ResultInterface
- See Also:
-
getVersionColumns
INTERNAL- Parameters:
catalog
- to inspectschema
- to inspecttable
- to inspect- Returns:
- ResultInterface
- See Also:
-
getPrimaryKeys
INTERNAL- Parameters:
catalog
- to inspectschema
- to inspecttable
- to inspect- Returns:
- ResultInterface
- See Also:
-
getImportedKeys
INTERNAL- Parameters:
catalog
- to inspectschema
- to inspecttable
- to inspect- Returns:
- ResultInterface
- See Also:
-
getExportedKeys
INTERNAL- Parameters:
catalog
- to inspectschema
- to inspecttable
- to inspect- Returns:
- ResultInterface
- See Also:
-
getCrossReference
public abstract ResultInterface getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) INTERNAL- Parameters:
primaryCatalog
- to inspectprimarySchema
- to inspectprimaryTable
- to inspectforeignCatalog
- to inspectforeignSchema
- to inspectforeignTable
- to inspect- Returns:
- ResultInterface
- See Also:
-
getTypeInfo
INTERNAL- Returns:
- ResultInterface
- See Also:
-
getIndexInfo
public abstract ResultInterface getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) INTERNAL- Parameters:
catalog
- to inspectschema
- to inspecttable
- to inspectunique
- onlyapproximate
- allowed- Returns:
- ResultInterface
- See Also:
-
getUDTs
public abstract ResultInterface getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter resulttypeNamePattern
- "LIKE" style pattern to filter resulttypes
- int[]- Returns:
- ResultInterface
- See Also:
-
getSuperTypes
public abstract ResultInterface getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter resulttypeNamePattern
- "LIKE" style pattern to filter result- Returns:
- ResultInterface
- See Also:
-
getSuperTables
public abstract ResultInterface getSuperTables(String catalog, String schemaPattern, String tableNamePattern) INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter resulttableNamePattern
- "LIKE" style pattern to filter result- Returns:
- ResultInterface
- See Also:
-
getAttributes
public abstract ResultInterface getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter resulttypeNamePattern
- "LIKE" style pattern to filter resultattributeNamePattern
- "LIKE" style pattern to filter result- Returns:
- ResultInterface
- See Also:
-
getDatabaseMajorVersion
public abstract int getDatabaseMajorVersion()INTERNAL- Returns:
- ResultInterface
- See Also:
-
getDatabaseMinorVersion
public abstract int getDatabaseMinorVersion()INTERNAL- Returns:
- ResultInterface
- See Also:
-
getSchemas
INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter result- Returns:
- ResultInterface
- See Also:
-
getFunctions
public abstract ResultInterface getFunctions(String catalog, String schemaPattern, String functionNamePattern) INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter resultfunctionNamePattern
- "LIKE" style pattern to filter result- Returns:
- ResultInterface
- See Also:
-
getFunctionColumns
public abstract ResultInterface getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter resultfunctionNamePattern
- "LIKE" style pattern to filter resultcolumnNamePattern
- "LIKE" style pattern to filter result- Returns:
- ResultInterface
- See Also:
-
getPseudoColumns
public abstract ResultInterface getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) INTERNAL- Parameters:
catalog
- to inspectschemaPattern
- "LIKE" style pattern to filter resulttableNamePattern
- "LIKE" style pattern to filter resultcolumnNamePattern
- "LIKE" style pattern to filter result- Returns:
- ResultInterface
- See Also:
-