MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Pobierz pdf (Strona 377)

100

101

Display Database Metadata

6-35

props =

AlterTableWithAddColumn: 1

AlterTableWithDropColumn: 1

ANSI92EntryLevelSQL: 1

...

A 1 for a given property indicates that the database supports that property. 0 means that

the database does not support the property.

For details about properties that the database supports, see the methods of the

DatabaseMetaData object on the Oracle Java website: http://docs.oracle.com/

javase/7/docs/api/java/sql/DatabaseMetaData.html.

Retrieve Catalog Metadata

Retrieve the names and types of tables in a catalog in the database using dbmeta and the

catalog name tutorial.

t = tables(dbmeta,'tutorial')

t =

'MSysAccessObjects' 'SYSTEM TABLE'

'MSysIMEXColumns' 'SYSTEM TABLE'

'MSysIMEXSpecs' 'SYSTEM TABLE'

'MSysObjects' 'SYSTEM TABLE'

'MSysQueries' 'SYSTEM TABLE'

'MSysRelationships' 'SYSTEM TABLE'

'inventoryTable' 'TABLE'

'productTable' 'TABLE'

'salesVolume' 'TABLE'

'suppliers' 'TABLE'

'yearlySales' 'TABLE'

'display' 'VIEW'

t contains the list of table names in the catalog in the first column and list of table types

in the second column.

Close the Database Connection

close(conn)

Komentarze do niniejszej Instrukcji

Brak uwag

MATLAB DATABASE TOOLBOX RELEASE NOTES Podręcznik Użytkownika Strona 377

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie MATLAB DATABASE TOOLBOX RELEASE NOTES