This is machine translation

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

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

Database Toolbox Functions

Alphabetical List By Category
attrRetrieve attributes of columns in fetched data set
catalogs(To be removed) Get database catalog names
closeClose and invalidate database and driver resource utilizer
closeClose MongoDB connection
colsRetrieve number of columns in fetched data set
columnnamesRetrieve names of columns in fetched data set
columnprivilegesList database column privileges
columnsReturn database table column names
commitMake database changes permanent
configureODBCDataSourceOpen ODBC Data Source Administrator dialog box
connectionRelational database connection
countCount total number of documents in MongoDB collection
createCollectionCreate MongoDB collection
cursorDatabase cursor
databaseConnect to database
databaseDatastoreDatastore for data in database
datainsertExport MATLAB data into database table
datastore(Not recommended) Create datastore to access collection of data in a database
distinctRetrieve distinct values for field in MongoDB collection
dmdConstruct database metadata object
dropCollectionDrop MongoDB collection
execExecute SQL statement and open cursor
executeCypherExecute Cypher query on Neo4j database
exportedkeys(To be removed) Retrieve information about exported foreign keys
fastinsertAdd MATLAB data to database tables
fetchImport data into MATLAB workspace from database cursor or from execution of SQL statement
fetchmultiImport data from multiple result sets
findRetrieve documents in MongoDB collection
get(To be removed) Retrieve object properties
getdatasourcesReturn names of ODBC and JDBC data sources
hasdataDetermine if data in DatabaseDatastore is available to read
importedkeys(To be removed) Return information about imported foreign keys
indexinfo(To be removed) Return indices and statistics for database tables
insertAdd MATLAB data to database tables
insertInsert one or multiple documents into MongoDB collection
isopenDetermine if database connection or database cursor is open
isopenDetermine if MongoDB connection is open
isreadonly(To be removed) Determine if database connection is read-only
logintimeout(To be removed) Set or get time allowed to establish database connection
mongoMongoDB connection
namecolumn(To be removed) Map resultset column name to resultset column index
neo4jConnect to Neo4j database
Neo4jConnectNeo4j database connection
Neo4jNodeNeo4j database node
neo4jStruct2DigraphConvert graph or relationship structure from Neo4j database to directed graph
nodeDegreeIn- and out-degree for each associated relationship type for Neo4j database node
nodeLabelsAll node labels in Neo4j database
nodeRelationTypesAssociated relationship types for Neo4j database node
ping(To be removed) Retrieve status information about database connection
previewReturn subset of data from DatabaseDatastore
primarykeys(To be removed) Get primary key information for database table or schema
procedurecolumns(To be removed) Get stored procedure parameters and result columns of catalogs
procedures(To be removed) Get stored procedures for catalogs
propertyKeysAll property keys in Neo4j database
querytimeoutGet time specified for SQL queries to succeed
readRead data in DatabaseDatastore
readallRead all data in DatabaseDatastore
relationTypesAll relationship types in Neo4j database
removeRemove one or multiple documents from MongoDB collection
resetReset DatabaseDatastore to initial state
resultset(To be removed) Construct resultset object
rollbackUndo database changes
rowsReturn number of rows in fetched data set
rsmd(To be removed) Construct resultset metadata object
runsqlscriptRun SQL script on database
runstoredprocedureCall stored procedure with and without input and output arguments
schemas(To be removed) Get database schema names
searchGraphSearch for subgraph or entire graph in Neo4j database
searchNodeSearch Neo4j database nodes by label or by property key and value
searchNodeByIDSearch for Neo4j database node by node identifier
searchRelationSearch relationships for Neo4j database node
selectExecute SQL SELECT statement and import data into MATLAB
set(To be removed) Set properties for database or cursor object
setdbprefsSet preferences for retrieval format, errors, NULLs, and more
splitsqlquerySplit SQL query using paging
sql2native(To be removed) Convert JDBC SQL grammar to SQL grammar native to system
sqliteSQLite connection
supports(To be removed) Detect whether property is supported by database metadata object
tableprivilegesReturn database table privileges
tablesReturn database table names
updateReplace data in database table with MATLAB data
updateUpdate one or multiple documents in MongoDB collection
widthReturn field size of column in fetched data set
Was this topic helpful?