Access to Data Dictionaries

The following utility predicates provide users the tools to access data dictionaries. Users of Quintus Prolog may note that these predicates are all PRODBI compatible. A brief description of these predicates is as follows:

odbc_show_schema(accessible)

Shows all accessible table names for the user. This list can be long!

odbc_show_schema(user)

Shows just those tables that belongs to user.

odbc_show_schema(tuples('Table'))

Shows the contents of the base 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,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.