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 |
CREATE INDEX |
See |
CREATE [TEMPORARY] TABLE / DROP TABLE |
See |
CREATE VIEW / ALTER VIEW / DROP VIEW |
See |
DELETE FROM |
See |
EXECUTE |
See |
INSERT INTO |
See |
ROLLBACK |
See |
START TRANSACTION |
See |
UPDATE |
See |
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.