Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Statements allowed in procedures, triggers, events, and batches

All SQL statements are acceptable in batches (including data definition statements such as CREATE TABLE, ALTER TABLE, and so on), with the exception of the following:

• ALTER DATABASE (syntax 3)
• CONNECT
• CREATE DATABASE
• CREATE DECRYPTED FILE
• CREATE ENCRYPTED FILE
• DISCONNECT
• DROP CONNECTION
• DROP DATABASE
• FORWARD TO
• Interactive SQL commands such as INPUT or OUTPUT
• PREPARE TO COMMIT
• STOP ENGINE

You can use COMMIT, ROLLBACK, and SAVEPOINT statements within procedures, triggers, events, and batches with certain restrictions. See Transactions and savepoints in procedures and triggers.

For more information, see the Usage for each SQL statement in SQL Statements.

Using SELECT statements in batches