Built-In Object Type: DBMetaData

Inherits All, JavaObject: java.sql.DatabaseMetaData
(MORE DESCRIPTION TO COME.)
Methods:
NameArgumentsDescription
getBestRowIdentifier
tablePattern
scope
nullable
Returns a TableData for the row identifiers matching tablePattern, scope and nullable. The tablePattern is a pattern in the form of catalog.schema.pattern. The scope can be one of these: "bestRowNotPseudo" (default), "bestRowPseudo", "bestRowSession", "bestRowTemporary" and "bestRowTransaction"; nullable is a boolean, default is true .
getCatalogs
  Returns a TableData for the catalogs in the database.
getColumnPrivileges
tablePattern
type
...
Returns a TableData for the column privileges matching tablePattern and type(s). The tablePattern is a pattern in the form of catalog.schema.pattern.
getColumns
tablePattern
type
...
Returns a TableData for the columns matching tablePattern and type(s). The tablePattern is a pattern in the form of catalog.schema.pattern.
getCrossReference
primaryTablePattern
foreignTablePattern
Returns a TableData for the cross reference for primaryTablePattern and foreignTablePattern. Both are patterns in the form of catalog.schema.pattern.
getExportddKeys
tablePattern
Returns a TableData for the exported keys matching tablePattern. The tablePattern is a pattern in the form of catalog.schema.pattern.
getImportddKeys
tablePattern
Returns a TableData for the imported keys matching tablePattern. The tablePattern is a pattern in the form of catalog.schema.pattern.
getIndexInfo
tablePattern
unique
approximate
Returns a TableData for the index information for tablePattern, unique and foreignTablePattern. The tablePattern is a pattern in the form of catalog.schema.pattern. The unique is boolean, default false . The approximate is boolean, default false .
getPrimaryKeys
tablePattern
Returns a TableData for the primary keys matching tablePattern. The tablePattern is a pattern in the form of catalog.schema.pattern.
getProcedureColumns
procPattern
columnPattern
Returns a TableData for the procedure columns matching procPattern and columnPattern. The procPattern is a pattern in the form of catalog.schema.pattern.
getProcedures
procPattern
Returns a TableData for the procedures matching procPattern. The procPattern is a pattern in the form of catalog.schema.pattern.
getSchemas
  Returns a TableData for the schemas in the database.
getTablePrivileges
tablePattern
Returns a TableData for the table privileges matching tablePattern. The tablePattern is a pattern in the form of catalog.schema.pattern.
getTableTypes
  Returns a TableData for the table types in the database.
getTables
tablePattern
columnPattern
Returns a TableData for the tables matching tablePattern and columnPattern(s). The tablePattern is a pattern in the form of catalog.schema.pattern.
getTypeInfo
  Returns a TableData for the type information in the database.
getUDTs
tablePattern
type
...
Returns a TableData for the user-defined types matching tablePattern and type(s). The type(s) can be "java_object", "struct" or "distinct". The tablePattern is a pattern in the form of catalog.schema.pattern.
getVersionColumns
tablePattern
Returns a TableData for the version columns matching tablePattern. The tablePattern is a pattern in the form of catalog.schema.pattern.
tableExists
tablePattern
Returns true if table tablePattern exists. The tablePattern is a pattern in the form of catalog.schema.pattern.