next up previous contents index
Next: Other Database Operations Up: Using the Interface Previous: Direct Execution of SQL   Contents   Index

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:

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



Baoqiu Cui
2000-04-23