GetTables - Maple Help

Connection

 GetTables
 get a list of tables from the database

 Calling Sequence connection:-GetTables( opts )

Parameters

 connection - Connection module opts - (optional) equation(s) of the form option=value where option is one of catalog, schema, table, or output

Description

 • GetTables returns an Array where each row of the Array contains matches from one table in the database connected to using connection.  A column in the Array is data associated with the table.  The output option controls the columns and their order in the returned Array.
 • The opts argument can contain one or more of the following equations.
 output = list containing a selection of symbols from: name, catalog, schema, and type
 The output option specifies the columns to return. The order of the columns in the output is the same as the order of the symbols in the list. By default, only the name is returned. Some databases do not support all of these fields.
 - name returns the name of the table.
 - catalog returns the name of the catalog that contains the table.
 - schema returns the name of the schema that the table uses.
 - type returns the type of the table.  These are a database-specific values. Typical results are "TABLE", "VIEW", "SYSTEM TABLE","GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", and "SYNONYM".
 catalog = string
 Return only columns from the specified catalog. To return columns from tables not in a catalog, specify the empty string ("").  By default, no restrictions are applied.
 schema = string
 Return only columns from databases in which the schema matches the specified pattern. The pattern can consist of any valid schema name characters and the special characters % and _. A % matches any string and an _ matches any character. To match a literal _ or %, you must prepend the escape character \.  For example to match a _ use \_. By default, no restrictions are applied.
 table = string
 Return only columns for which the table matches the specified pattern. The pattern can consist of any valid table name characters and the special characters % and _. A % matches any string and an _ matches any character. To match a literal _ or %, you must prepend the escape character \.  For example to match a _ use \_. By default, no restrictions are applied.

Examples

 > $\mathrm{driver}≔\mathrm{Database}\left[\mathrm{LoadDriver}\right]\left(\right):$
 > $\mathrm{conn}≔\mathrm{driver}:-\mathrm{OpenConnection}\left(\mathrm{url},\mathrm{name},\mathrm{pass}\right):$$\mathrm{conn}:-\mathrm{GetTables}\left('\mathrm{output}'=\left['\mathrm{schema}','\mathrm{name}'\right]\right)$
 $\left[\begin{array}{cc}{"Schema1"}& {"Table1"}\\ {"Schema1"}& {"Table2"}\\ {"Schema2"}& {"Table3"}\\ {"Schema2"}& {"Table4"}\\ {"Schema3"}& {"Table5"}\end{array}\right]$ (1)
 > $\mathrm{conn}:-\mathrm{GetTables}\left('\mathrm{schema}'="%1",'\mathrm{output}'=\left['\mathrm{name}'\right]\right)$
 $\left[\begin{array}{c}{"Table1"}\\ {"Table2"}\end{array}\right]$ (2)
 > $\mathrm{conn}:-\mathrm{GetTables}\left('\mathrm{table}'="%1",'\mathrm{output}'=\left['\mathrm{name}','\mathrm{schema}','\mathrm{type}'\right]\right)$
 $\left[{"Table1"}{,}{"Schema1"}{,}{"TABLE"}\right]$ (3)