Supported Statements

The following DDL 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 Dynamic SQL.

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