Database Toolbox Functions

Alphabetical List By Category
attr Retrieve attributes of columns in fetched data set
bestrowid (Not recommended) Unique identifier for row in database table
catalogs Get database catalog names
clearwarnings (Not recommended) Clear warnings for database connection or resultset
close Close database connection, SQLite connection, DatabaseDatastore, cursor, or resultset object
cols Retrieve number of columns in fetched data set
columnnames Retrieve names of columns in fetched data set
columnprivileges List database column privileges
columns Return database table column names
commit Make database changes permanent
confds Configure JDBC data source for Visual Query Builder
crossreference (Not recommended) Retrieve information about primary and foreign keys
cursor.fetch Import data into MATLAB Workspace from cursor object created by exec
database Connect to database
database.catalogs Get database catalog names
database.columns Get database table column names
database.fetch Execute SQL statement to import data into MATLAB workspace
database.schemas Get database schema names
database.tables Get database table names
DatabaseDatastore Access collection of data stored in database
datainsert Export MATLAB data into database table
datastore Create datastore to access collection of data in a database
dmd Construct database metadata object
driver Construct database driver object
drivermanager Construct database drivermanager object
exec Execute SQL statement and open cursor
exportedkeys Retrieve information about exported foreign keys
fastinsert Add MATLAB data to database table
fetch Import data into MATLAB workspace from cursor object or from execution of SQL statement
fetchmulti Import data from multiple resultsets
get Retrieve object properties
getdatasources Return names of ODBC and JDBC data sources on system
hasdata Determine if cursor in DatabaseDatastore contains more data
importedkeys Return information about imported foreign keys
indexinfo Return indices and statistics for database tables
insert Add MATLAB data to database tables
isconnection (Not recommended) Determine if database connections are valid
isdriver Detect whether driver is valid JDBC driver object
isjdbc Detect whether driver is JDBC compliant
isnullcolumn (Not recommended) Determine if last record read in resultset is NULL
isopen Determine if database connection or database cursor is open
isreadonly Determine if database connection is read only
isurl Detect whether database URL is valid
logintimeout Set or get time allowed to establish database connection
namecolumn Map resultset column name to resultset column index
ping Retrieve status information about database connection
preview Display first eight records of data in DatabaseDatastore
primarykeys Get primary key information for database table or schema
procedurecolumns Get stored procedure parameters and result columns of catalogs
procedures Get stored procedures for catalogs
querybuilder (Not recommended) Start Visual Query Builder GUI to import and export data
querytimeout Get time specified for SQL queries to succeed
read Read data in DatabaseDatastore
readall Read every record in DatabaseDatastore
register Load database driver
reset Reset cursor position in DatabaseDatastore
resultset Construct resultset object
rollback Undo database changes
rows Return number of rows in fetched data set
rsmd Construct resultset metadata object
runsqlscript Run SQL script on database
runstoredprocedure Call stored procedure with and without input and output arguments
schemas Get database schema names
set Set properties for database, cursor, or drivermanager object
setdbprefs Set preferences for retrieval format, errors, NULLs, and more
sql2native Convert JDBC SQL grammar to SQL grammar native to system
sqlite Create SQLite connection
supports Detect whether property is supported by database metadata object
tableprivileges Return database table privileges
tables Return database table names
unregister Unload database driver
update Replace data in database table with MATLAB data
versioncolumns (Not recommended) Automatically update table columns
width Return field size of column in fetched data set
Was this topic helpful?