SQL Script Keywords
SQL Script keywords are the character strings that SQL Script treats as reserved words.
Note: TDV does not treat all SQL-99 reserved words as SQL Script keywords.
SQL Script keywords are not case-sensitive. However, TDV documentation uses uppercase letters to distinguish keywords from other words.
Although it is not recommended, you can use SQL Script keywords in roles other than their intended syntax, as long as you set them off in double quotes. For example:
SELECT "BEGIN" INTO ...
The following table lists the SQL Script keywords.
|
SQL Script Keywords |
|||
|
AS |
BEGIN |
CALL |
CASE |
|
CAST |
CLOSE |
COMMIT |
CREATE |
|
DROP |
CURRENT_EXCEPTION |
CURSOR |
DO |
|
DECLARE |
DEFAULT |
DELETE |
ELSE |
|
ELSE IF |
END |
EXCEPTION |
EXECUTE |
|
FALSE |
FETCH |
FOR |
IF |
|
IMMEDIATE |
IN |
INDEPENDENT |
INOUT |
|
INSERT INTO |
INTO |
ITERATE |
LEAVE |
|
LOOP |
OPEN |
OUT |
PIPE |
|
PROCEDURE |
PUBLIC |
RAISE |
REPEAT |
|
ROLLBACK |
ROW |
SELECT |
SET |
|
THEN |
TRANSACTION |
TRUE |
TRUNCATE |
|
TYPE |
UNTIL |
UPDATE |
VALUE |
|
WHEN |
WHILE |
|
|