Skip to main content

Generic_JDBC_Connection.tables

tablesname_likedatabaseschematable_types

Group: Metadata
Aliases: catalog schema database table

Documentation​

Returns a Vector of the available tables.

Arguments​

  • database: A pattern specifying the database or databases to get tables for. If tables is "", returns tables for current database.
  • schema: A pattern specifying the schemas to get tables for. If schema is "", return tables for all schemas.
  • table_name_pattern: A pattern specifying the tables to return. If table_name_pattern is Nothing, return all tables.
  • table_types: A Vector of table type names to include. If table_types is Nothing, return all types of tables.

Examples​

Get the available schemas.​

      connection = Generic_JDBC_Connection.connect "jdbc:h2:~/my_database"
      connection.tables

Remarks​

Patterns​

Patterns can be literal strings, or can include wildcard characters. The wildcard characters are the same ones that are used in SQL LIKE clauses.

Examples:

  • "A": matches the table "A".
  • "A_": matches the tables "AB" and "AC".
  • "A%": matches the tables "ABC" and "ADEF".