User`s guide

Display Database Metadata

6-35

props =

AlterTableWithAddColumn: 1

AlterTableWithDropColumn: 1

ANSI92EntryLevelSQL: 1

...

A 1 for a given property indicates that the database supports that property. 0 means that

the database does not support the property.

For details about properties that the database supports, see the methods of the

DatabaseMetaData object on the Oracle Java website: http://docs.oracle.com/

javase/7/docs/api/java/sql/DatabaseMetaData.html.

Retrieve Catalog Metadata

Retrieve the names and types of tables in a catalog in the database using dbmeta and the

catalog name tutorial.

t = tables(dbmeta,'tutorial')

t =

'MSysAccessObjects' 'SYSTEM TABLE'

'MSysIMEXColumns' 'SYSTEM TABLE'

'MSysIMEXSpecs' 'SYSTEM TABLE'

'MSysObjects' 'SYSTEM TABLE'

'MSysQueries' 'SYSTEM TABLE'

'MSysRelationships' 'SYSTEM TABLE'

'inventoryTable' 'TABLE'

'productTable' 'TABLE'

'salesVolume' 'TABLE'

'suppliers' 'TABLE'

'yearlySales' 'TABLE'

'display' 'VIEW'

t contains the list of table names in the catalog in the first column and list of table types

in the second column.

Close the Database Connection

close(conn)