Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

View Information About Database

Information about relational database structure

You can explore database contents and structure visually using the Database Explorer app. Or, you can use the command line.

Functions

catalogs(To be removed) Get database catalog names
columnsReturn database table column names
schemas(To be removed) Get database schema names
tablesReturn database table names
get(To be removed) Retrieve object properties
getdatasourcesReturn names of ODBC and JDBC data sources
isopenDetermine if database connection or database cursor is open
isreadonly(To be removed) Determine if database connection is read-only
ping(To be removed) Retrieve status information about database connection
columnprivilegesList database column privileges
columnsReturn database table column names
dmdConstruct database metadata object
tableprivilegesReturn database table privileges
tablesReturn database table names

Apps

Database ExplorerConfigure, explore, and import database data

Topics

Display Database Metadata

This example shows how to display database information for connection objects using the command line.

Data Retrieval Restrictions

Find restrictions on table and column names for data retrieval.

Was this topic helpful?