User`s guide

7 Functions — Alphabetical List
7-238
tables
Return database table names
Syntax
t = tables(dbmeta, 'cata')
t = tables(dbmeta, 'cata', 'sch')
Description
t = tables(dbmeta, 'cata') returns a list of tables and table types in the catalog
cata for the database whose database metadata object is dbmeta resulting from a
database connection object.
t = tables(dbmeta, 'cata', 'sch') returns a list of tables and table types in the
schema sch, of the catalog cata, for the database whose database metadata object is
dbmeta resulting from a database connection object.
Tip For command-line help on tables, use the overloaded method:
help dmd/tables
Examples
Get the table names and types for the schema SCOTT in the catalog orcl, for the
database metadata object dbmeta.
t = tables(dbmeta,'orcl', 'SCOTT')
t =
'BONUS' 'TABLE'
'DEPT' 'TABLE'
'EMP' 'TABLE'
'SALGRADE' 'TABLE'
'TRIAL' 'TABLE'