29. Зарезервированные и ключевые слова

Зарезервированные слова нельзя использовать в качестве имен объектов базы данных, переменных и параметров. Список зарезервированных слов представлен в таблице 29.1. Не рекомендуется использовать и ключевые слова как имена объектов базы данных, поскольку не исключена вероятность перевода их в разряд зарезервированных в следующих версиях системы управления базами данных.

Таблица 29.1 Список зарезервированных слов SQL РЕД База Данных

ADD	ADMIN	ALL
ALTER	AND	ANY
AS	AT	AVG
BEGIN	BETWEEN	BIGINT
BINARY	BIT_LENGTH	BLOB
BOOLEAN	BOTH	BY
CALL	CASE	CAST
CHAR	CHARACTER	CHARACTER_LENGTH
CHAR_LENGTH	CHECK	CLOSE
COLLATE	COLUMN	COMMENT
COMMIT	CONNECT	CONSTRAINT
CORR	COUNT	COVAR_POP
COVAR_SAMP	CREATE	CROSS
CURRENT	CURRENT_DATE	CURRENT_ROLE
CURRENT_CONNECTION	CURRENT_TIME	CURRENT_TIMESTAMP
CURRENT_TRANSACTION	CURRENT_USER	CURSOR
DATE	DAY	DEC
DECFLOAT	DECIMAL	DECLARE
DEFAULT	DELETE	DELETING
DETERMINISTIC	DISCONNECT	DISTINCT
DOUBLE	DROP	ELSE
END	ESCAPE	EXECUTE
EXISTS	EXTERNAL	EXTRACT
FALSE	FETCH	FILTER
FLOAT	FOR	FOREIGN
FROM	FULL	FUNCTION
GDSCODE	GLOBAL	GRANT
GROUP	HAVING	HOUR
IN	INDEX	INNER
INSENSITIVE	INSERT	INSERTING
INT	INT128	INTEGER
INTO	IS	JOIN
LATERAL	LEADING	LEFT
LIKE	LOCAL	LOCALTIME
LOCALTIMESTAMP	LONG	LOWER
MAX	MERGE	MIN
MINUTE	MONTH	NATIONAL
NATURAL	NCHAR	NO
NOT	NULL	NUMERIC
OCTET_LENGTH	OF	OFFSET
ON	ONLY	OPEN
OR	ORDER	OUTER
OVER	PARAMETER	PLAN
POSITION	POST_EVENT	PRECISION
PRIMARY	PROCEDURE	PUBLICATION
RDB$DB_KEY	RDB$ERROR	RDB$GET_CONTEXT
RDB$RECORD_VERSION	RDB$ROLE_IN_USE	RDB$SET_CONTEXT
RDB$SYSTEM_PRIVILEGE	REAL	RECORD_VERSION
RECREATE	RECURSIVE	RDB$GET_TRANSACTION_CN
REFERENCES	REGR_AVGX	REGR_AVGY
REGR_COUNT	REGR_INTERCEPT	REGR_R2
REGR_SLOPE	REGR_SXX	REGR_SXY
REGR_SYY	RELEASE	RESETTING
RETURN	RETURNING_VALUES	RETURNS
REVOKE	RIGHT	ROLLBACK
ROW	ROWS	ROW_COUNT
SAVEPOINT	SCROLL	SECOND
SELECT	SENSITIVE	SET
SIMILAR	SMALLINT	SOME
SQLCODE	SQLSTATE	START
STDDEV_POP	STDDEV_SAMP	SUM
TABLE	THEN	TIME
TIMESTAMP	TIMEZONE_HOUR	TIMEZONE_MINUTE
TO	TRAILING	TRIGGER
TRIM	TRUE	UNBOUNDED
UNION	UNIQUE	UNKNOWN
UPDATE	UPDATING	UPPER
USER	USING	VALUE
VALUES	VARBINARY	VARCHAR
VARIABLE	VARYING	VAR_POP
VAR_SAMP	VIEW	WHEN
WHERE	WHILE	WINDOW
WITH	WITHOUT	YEAR

В таблице 29.2 представлен список ключевых слов. Это слова, используемые в операторах SQL, но которые в принципе можно использовать в качестве имен объектов базы данных.

Таблица 29.2 Список ключевых слов SQL РЕД База Данных

!<	!=	!>
(	)	,
<	<=	<>
=	>	>=
:=	^<	^=
^>	||	~<
~=	~>	ABS
ABSOLUTE	ACCENT	ACOS
ACOSH	ACTION	ACTIVE
ADD	ADMIN	AFTER
ALL	ALTER	ALWAYS
AND	ANY	AS
ASC	ASCENDING	ASCII_CHAR
ASCII_VAL	ASIN	ASINH
AT	ATAN	ATAN2
ATANH	AUTO	AUTONOMOUS
AVG	BACKUP	BASE64_DECODE
BASE64_ENCODE	BEFORE	BEGIN
BETWEEN	BIGINT	BINARY
BIND	BIN_AND	BIN_NOT
BIN_OR	BIN_SHL	BIN_SHR
BIN_XOR	BIT_LENGTH	BLOB
BLOCK	BODY	BOOLEAN
BOTH	BREAK	BY
CALLER	CASCADE	CASE
CAST	CEIL	CEILING
CHAR	CHARACTER	CHARACTER_LENGTH
CHAR_LENGTH	CHAR_TO_UUID	CHECK
CLEAR	CLOSE	COALESCE
COLLATE	COLLATION	COLUMN
COMMENT	COMMIT	COMMITTED
COMMON	COMPARE_DECFLOAT	COMPUTED
CONDITIONAL	CONNECT	CONNECTIONS
CONSISTENCY	CONSTRAINT	CONTAINING
CONTINUE	CORR	COS
COSH	COT	COUNT
COUNTER	COVAR_POP	COVAR_SAMP
CREATE	CROSS	CRYPT_HASH
CSTRING	CTR_BIG_ENDIAN	CTR_LENGTH
CTR_LITTLE_ENDIAN	CUME_DIST	CURRENT
CURRENT_CONNECTION	CURRENT_DATE	CURRENT_ROLE
CURRENT_TIME	CURRENT_TIMESTAMP	CURRENT_TRANSACTION
CURRENT_USER	CURSOR	DATA
DATABASE	DATE	DATEADD
DATEDIFF	DAY	DDL
DEBUG	DEC	DECFLOAT
DECIMAL	DECLARE	DECODE
DECRYPT	DEFAULT	DEFINER
DELETE	DELETING	DENSE_RANK
DESC	DESCENDING	DESCRIPTOR
DETERMINISTIC	DIFFERENCE	DISABLE
DISCONNECT	DISTINCT	DO
DOMAIN	DOUBLE	DROP
ELSE	ENABLE	ENCRYPT
END	ENGINE	ENTRY_POINT
ESCAPE	EXCEPTION	EXCESS
EXCLUDE	EXECUTE	EXISTS
EXIT	EXP	EXTENDED
EXTERNAL	EXTRACT	FALSE
FETCH	FILE	FILTER
FIRST	FIRSTNAME	FIRST_DAY
FIRST_VALUE	FLOAT	FLOOR
FOLLOWING	FOR	FOREIGN
FREE_IT	FROM	FULL
FUNCTION	GDSCODE	GENERATED
GENERATOR	GEN_ID	GEN_UUID
GLOBAL	GRANT	GRANTED
GROUP	HASH	HAVING
HEX_DECODE	HEX_ENCODE	HOUR
IDENTITY	IDLE	IF
IGNORE	IIF	IN
INACTIVE	INCLUDE	INCREMENT
INDEX	INNER	INPUT_TYPE
INSENSITIVE	INSERT	INSERTING
INT	INT128	INTEGER
INTO	INVOKER	IS
ISOLATION	IV	JOIN
KEY	LAG	LAST
LASTNAME	LAST_DAY	LAST_VALUE
LATERAL	LEAD	LEADING
LEAVE	LEFT	LEGACY
LENGTH	LEVEL	LIFETIME
LIKE	LIMBO	LINGER
LIST	LN	LOCAL
LOCALTIME	LOCALTIMESTAMP	LOCK
LOG	LOG10	LONG
LOWER	LPAD	LPARAM
MAKE_DBKEY	MANUAL	MAPPING
MATCHED	MATCHING	MAX
MAXVALUE	MERGE	MESSAGE
MIDDLENAME	MILLISECOND	MIN
MINUTE	MINVALUE	MOD
MODE	MODULE_NAME	MONTH
NAME	NAMES	NATIONAL
NATIVE	NATURAL	NCHAR
NEXT	NO	NORMALIZE_DECFLOAT
NOT	NTH_VALUE	NTILE
NULL	NULLIF	NULLS
NUMBER	NUMERIC	OCTET_LENGTH
OF	OFFSET	OLDEST
ON	ONLY	OPEN
OPTION	OR	ORDER
OS_NAME	OTHERS	OUTER
OUTPUT_TYPE	OVER	OVERFLOW
OVERLAY	OVERRIDING	PACKAGE
PAD	PAGE	PAGES
PAGE_SIZE	PARAMETER	PARTITION
PASSWORD	PERCENT_RANK	PI
PKCS_1_5	PLACING	PLAN
PLUGIN	POOL	POSITION
POST_EVENT	POWER	PRECEDING
PRECISION	PRESERVE	PRIMARY
PRIOR	PRIVILEGE	PRIVILEGES
PROCEDURE	PROTECTED	PUBLICATION
QUANTIZE	RAND	RANGE
RANK	RDB$DB_KEY	RDB$ERROR
RDB$GET_CONTEXT	RDB$GET_TRANSACTION_CN	RDB$RECORD_VERSION
RDB$ROLE_IN_USE	RDB$SET_CONTEXT	RDB$SYSTEM_PRIVILEGE
READ	REAL	RECORD_VERSION
RECREATE	RECURSIVE	REFERENCES
REGR_AVGX	REGR_AVGY	REGR_COUNT
REGR_INTERCEPT	REGR_R2	REGR_SLOPE
REGR_SXX	REGR_SXY	REGR_SYY
RELATIVE	RELEASE	REPLACE
REQUESTS	RESERV	RESERVING
RESET	RESETTING	RESTART
RESTRICT	RETAIN	RETURN
RETURNING	RETURNING_VALUES	RETURNS
REVERSE	REVOKE	RIGHT
ROLE	ROLLBACK	ROUND
ROW	ROWS	ROW_COUNT
ROW_NUMBER	RPAD	RSA_DECRYPT
RSA_ENCRYPT	RSA_PRIVATE	RSA_PUBLIC
RSA_SIGN_HASH	RSA_VERIFY_HASH	SALT_LENGTH
SAVEPOINT	SCALAR_ARRAY	SCHEMA
SCROLL	SECOND	SECURITY
SEGMENT	SELECT	SENSITIVE
SEQUENCE	SERVERWIDE	SESSION
SET	SHADOW	SHARED
SIGN	SIGNATURE	SIMILAR
SIN	SINGULAR	SINH
SIZE	SKIP	SMALLINT
SNAPSHOT	SOME	SORT
SOURCE	SPACE	SQL
SQLCODE	SQLSTATE	SQRT
STABILITY	START	STARTING
STARTS	STATEMENT	STATISTICS
STDDEV_POP	STDDEV_SAMP	SUBSTRING
SUB_TYPE	SUM	SUSPEND
SYSTEM	TABLE	TAGS
TAN	TANH	TEMPORARY
THEN	TIES	TIME
TIMEOUT	TIMESTAMP	TIMEZONE_HOUR
TIMEZONE_MINUTE	TO	TOTALORDER
TRAILING	TRANSACTION	TRAPS
TRIGGER	TRIM	TRUE
TRUNC	TRUSTED	TWO_PHASE
TYPE	UNBOUNDED	UNCOMMITTED
UNDO	UNION	UNIQUE
UNKNOWN	UPDATE	UPDATING
UPPER	USAGE	USER
USING	UUID_TO_CHAR	VALUE
VALUES	VARBINARY	VARCHAR
VARIABLE	VARYING	VAR_POP
VAR_SAMP	VIEW	WAIT
WEEK	WEEKDAY	WHEN
WHERE	WHILE	WINDOW
WITH	WITHOUT	WORK
WRITE	YEAR	YEARDAY
ZONE