Database Toolbox™

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.

• 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

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' 

See Also

attr, bestrowid, dmd, get, indexinfo, tableprivileges

tableprivileges

unregister