Connect to Database Programmatically

Establish connection to relational databases and retrieve information about their structures using command line

Database Toolbox™ enables you to connect to various relational databases by installing the database and driver. If you do not want to install a database and driver, you can use the MATLAB Interface to SQLite.

After establishing a database connection, you can explore database contents and structure using the command line. Close the database connection when you are finished.

Objects

`connection`	Relational database ODBC connection
`connection`	Relational database JDBC connection

Functions

expand all

Database Connections

`close`	Close and invalidate database and driver resource utilizer
`database`	Connect to database
`isopen`	Determine if database connection is open
`odbc`	Create ODBC database connection (Since R2021a)

Information About Database Structure

`listDataSources`	List all available data sources (Since R2020b)
`sqlfind`	Find information about all table types in database

Topics

Connect to Database

Connect to Database
After configuring a driver and data source, connect to your database.
Interact with Data in SQLite Database Using MATLAB Interface to SQLite
Analyze data without access to a database or driver by using the MATLAB^® interface to SQLite.

Retrieve Information About Database Structure

Retrieve Database Metadata
Find information about the database, tables, and columns using the connection object and the sqlfind function.
Data Retrieval Restrictions
Identify restrictions on table and column names for data retrieval.