Documentation

Database Operations

Run stored procedure or custom function, alter structure of database, manage database transactions, and switch between catalogs

You can use theexecutefunction and other Database Toolbox™ functionality to perform numerous database operations. For example, use therunstoredprocedurefunction to run a stored procedure. You can alter database structure by creating tables and adding columns. Therollbackand提交functions enable you to manage database transactions. Or, you can execute the corresponding SQL statements by using theexecutefunction.

Functions

expand all

execute Execute SQL statement using relational database connection
提交 Make database changes permanent
rollback Undo database changes
runstoredprocedure Call stored procedure with and without input and output arguments
exec Execute SQL statement using SQLite connection

Topics

Run Custom Database Function

Run a custom database function onMicrosoft®SQL Server®.

Change Database Connection Catalog

Switch between different database catalogs.

Roll Back Data in Database

ExecuteROLLBACKSQL statement by using theexecutefunction.

Create Table and Add Column

Manage database structures using the创建andALTERSQL statements.

Delete Data from Databases

Delete data from your database using MATLAB®.

Database Toolbox Documentation
金宝app

Try MATLAB, Simulink, and Other Products

Get trial now