tables (Database Toolbox)

Get database table names

Syntax

t = tables(dbmeta, 'cata')
t = tables(dbmeta, 'cata', 'sch')

Description

t = tables(dbmeta, 'cata') returns the list of all tables and their table types in the catalog cata, for the database whose database metadata object is dbmeta, where dbmeta was created using dmd.

t = tables(dbmeta, 'cata', 'sch') returns the list of tables and table types in the schema sch, of the catalog cata, for the database whose database metadata object is dbmeta, where dbmeta was created using dmd.

For command line help on tables, use the overloaded method

```
help dmd/tables
```

Examples

Type

```
t = tables(dbmeta,'orcl', 'SCOTT')
```

MATLAB returns

t = 
    'BONUS'       'TABLE'
    'DEPT'        'TABLE'
    'EMP'         'TABLE'
    'SALGRADE'    'TABLE'
    'TRIAL'       'TABLE'

In this example:

dbmeta is the database metadata object.
orcl is the catalog cata.
SCOTT is the schema sch.

The results show the names and types of the five tables.

See Also

attr, bestrowid, dmd, get, indexinfo, tableprivileges

tableprivileges unregister