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' 
Was this topic helpful?