4.2.9 Access to Data Dictionaries

The following utility predicates provide users with tools to access data dictionaries ^4.3. A brief description of these predicates is as follows:

odbc_show_schema(accessible(Owner))

Shows the names of all accessible tables that are owned by Owner. (This list can be long!) If Owner is a variable, all tables will be shown, grouped by owner.

odbc_show_schema(user)

Shows just those tables that belongs to user.

odbc_show_schema(tuples('Table'))

Shows all rows of the database table named 'Table'.

odbc_show_schema(arity('Table'))

The number of fields in the table 'Table'.

odbc_show_schema(columns('Table'))

The field names of a table.

For retrieving above information use:

• odbc_get_schema(accessible(Owner),List)
• odbc_get_schema(user,List)
• odbc_get_schema(arity('Table'),List)
• odbc_get_schema(columns('Table'),List)

The results of above are returned in List as a list.