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'

Search MATLAB Documentation
R2011b Documentation → Database Toolbox
View documentation for other releases	Learn more about Database Toolbox

tables - Return database table names

Syntax

Description

Examples

See Also

Recommended Products