[firebase-br] Lista com todas as palavras reservadas

Eduardo Jedliczka (TeamFB) jedyfb em gmail.com
Seg Jul 17 13:19:03 -03 2006


Reserved Words

[KEYWORD] marks words that are not currently reserved words but should be 
treated as such for planned future implementation or for compatibility with 
InterBase.
/* KEYWORD */ marks words that are reserved words in Firebird 1.0.x but were 
released in Firebird 1.5.
Há palavras que são reservadas apenas em alguns contextos.

[ABS]
ACTION
ACTIVE
ADD
ADMIN
AFTER
ALL
ALTER
AND
ANY
ARE
AS
ASC
ASCENDING
AT
AUTO
AUTODDL
AVG
BASED
BASENAME
BASE_NAME
BEFORE
BEGIN
BETWEEN
BIGINT
BLOB
BLOBEDIT
[BOOLEAN]
[BOTH]
/* BREAK */
BUFFER
BY
CACHE
CASCADE
CASE
CAST
CHAR
CHARACTER
[CHAR_LENGTH]
[CHARACTER_LENGTH]
CHECK
CHECK_POINT_LEN
CHECK_POINT_LENGTH
CLOSE
COALESCE
COLLATE
COLLATION
COLUMN
COMMIT
COMMITTED
COMPILETIME
COMPUTED
CONDITIONAL
CONNECT
CONSTRAINT
CONTAINING
CONTINUE
COUNT
CREATE
CSTRING
CURRENT
CURRENT_CONNECTION
CURRENT_DATE
CURRENT_ROLE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TRANSACTION
CURRENT_USER
DATABASE
DATE
DAY
DB_KEY
DEBUG
DEC
DECIMAL
DECLARE
DEFAULT
[DEFERRED]
DELETE
DELETING
DESC
DESCENDING
DESCRIBE
/* DESCRIPTOR */
DISCONNECT
DISPLAY
DISTINCT
DO
DOMAIN
DOUBLE
DROP
ECHO
EDIT
ELSE
END
ENTRY_POINT
ESCAPE
EVENT
EXCEPTION
EXECUTE
EXISTS
EXIT
EXTERN
EXTERNAL
EXTRACT
[FALSE]
FETCH
FILE
FILTER
/* FIRST */
FLOAT
FOR
FOREIGN
FOUND
FREE_IT
FROM
FULL
FUNCTION
GDSCODE
GENERATOR
GEN_ID
[GLOBAL]
GOTO
GRANT
GROUP
GROUP_COMMIT_WAIT
GROUP_COMMIT_WAIT_TIME
HAVING
HEADING
HELP
HOUR
IF
/* IIF */
IMMEDIATE
IN
INACTIVE
INDEX
INDICATOR
INIT
INNER
INPUT
INPUT_TYPE
INSERT
INSERTING
INT
INTEGER
INTO
IS
ISOLATION
ISQL
JOIN
KEY
LAST
LC_MESSAGES
LC_TYPE
[LEADING]
LEAVE
LEFT
LENGTH
LEV
LEVEL
LIKE
LOCK
LOGFILE
LOG_BUFFER_SIZE
LOG_BUF_SIZE
LONG
MANUAL
MAX
MAXIMUM
MAXIMUM_SEGMENT
MAX_SEGMENT
MERGE
MESSAGE
MIN
MINIMUM
MINUTE
MODULE_NAME
MONTH
NAMES
NATIONAL
NATURAL
NCHAR
NO
NOAUTO
NOT
NULL
NULLIF
NULLS
NUM_LOG_BUFS
NUM_LOG_BUFFERS
NUMERIC
[OCTET_LENGTH]
OF
ON
ONLY
OPEN
OPTION
OR
ORDER
OUTER
OUTPUT
OUTPUT_TYPE
OVERFLOW
PAGE
PAGELENGTH
PAGES
PAGE_SIZE
PARAMETER
PASSWORD
[PERCENT]
PLAN
POSITION
POST_EVENT
PRECISION
PREPARE
[PRESERVE]
PRIMARY
PRIVILEGES
PROCEDURE
PUBLIC
QUIT
RAW_PARTITIONS
RDB$DB_KEY
READ
REAL
RECORD_VERSION
RECREATE
REFERENCES
RELEASE
RESERV
RESERVING
RESTRICT
RETAIN
RETURN
RETURNING_VALUES
RETURNS
REVOKE
RIGHT
ROLE
ROLLBACK
ROW_COUNT
[ROWS]
RUNTIME
SAVEPOINT
SCHEMA
SECOND
SELECT
SET
SHADOW
SHARED
SHELL
SHOW
SINGULAR
SIZE
/* SKIP */
SMALLINT
SNAPSHOT
SOME
SORT
SQL
SQLCODE
SQLERROR
SQLWARNING
STABILITY
STARTING
STARTS
STATEMENT
STATIC
STATISTICS
SUB_TYPE
/* SUBSTRING */
SUM
SUSPEND
TABLE
[TEMPORARY]
TERM
TERMINATOR
THEN
[TIES]
TIME
TIMESTAMP
TO
[TRAILING]
TRANSACTION
TRANSLATE
TRANSLATION
TRIGGER
[TRIM]
[TRUE]
TYPE
UNCOMMITTED
UNION
UNIQUE
[UNKNOWN]
UPDATE
UPDATING
UPPER
USER
USING
VALUE
VALUES
VARCHAR
VARIABLE
VARYING
VERSION
VIEW
WAIT
WEEKDAY
WHEN
WHENEVER
WHERE
WHILE
WITH
WORK
WRITE
YEAR
YEARDAY

Fonte: The FireBird Book Helen Borrie.

======================
Eduardo Jedliczka
Membro do TeamFB - FireBase
Apucarana - PR
======================

----- Original Message ----- 
From: "Claudir Pereira dos Santos" <claupers_dbrays em yahoo.com.br>
To: <lista em firebase.com.br>
Sent: Monday, July 17, 2006 12:26 PM
Subject: [firebase-br] Lista com todas as palavras reservadas


> Pessoal, ja procurei no google e não encontrei. O que encontrei foi 
> somente
> as novas palavras reservadas. Precisso para um programa de converção de
> arquivo dbf para código sql, pois tive um problema com uma base aqui que o
> desenvolvedor usou algumas palavras que se confundem com as reservadas.
>
> Um exemplo: Para indicar qual a naturalidade da pessoa ele usou NATURAL 
> que
> é uma palavra reservada, então da erro no sql. Preciso então de todas as
> palavras reservadas para chequer se o nome da coluna é uma palavra 
> reservada
> para que eu possa por exemplo atribuir algo mais como NATURAL1.
>
> Desde ja agradeço;
>
>
> Cordialmente
>
> Claudir Pereira dos Santos





Mais detalhes sobre a lista de discussão lista