SQL Statements Supported in Procedures, UDFs and Triggers

The following SQL statements are available for use in stored procedures, user defined functions (UDFs), and triggers. These statements are documented under SQL Statements.

Statement For more information...
COMMIT See COMMIT.
CREATE INDEX
(Stored Procedure only)
See CREATE INDEX.
CREATE [TEMPORARY] TABLE / DROP TABLE
(Stored Procedure only)
See CREATE TABLE / See DROP TABLE.
CREATE VIEW / ALTER VIEW / DROP VIEW
(Stored Procedure only)
See CREATE VIEW / See ALTER VIEW / See DROP VIEW.
DELETE FROM See DELETE.
EXECUTE See EXECUTE.
INSERT INTO See INSERT.
ROLLBACK See ROLLBACK.
START TRANSACTION See START TRANSACTION.
UPDATE See UPDATE.

Other SQL statements may be executed using dynamic SQL and EXECUTE IMMEDIATE. See SQL Procedural Dynamic SQL,

Note:
The CREATE TABLE / DROP TABLE statements support temporary, in-memory tables. See Creating Database Objects in Stored Procedures.