Database Operations
Run stored procedure or custom function, alter structure of database, manage database transactions, and switch between catalogs
You can use theexecute
function and other Database Toolbox™ functionality to perform numerous database operations. For example, use therunstoredprocedure
function to run a stored procedure. You can alter database structure by creating tables and adding columns. Therollback
andcommit
functions enable you to manage database transactions. Or, you can execute the corresponding SQL statements by using theexecute
function.
Functions
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
Execute
ROLLBACK
SQL statement by using theexecute
function. - Create Table and Add Column
Manage database structures using the
创建
andALTER
SQL statements. - Delete Data from Databases
Delete data from your database using MATLAB®.