Appendix C. Reserved words for SQLTable of Contents
The following lists contain words that are used internally by Kexi when dealing with data sources.
Warning
When designing your database you should do your best to avoid using these reserved words because otherwise you might end up having problems with your database file or even corrupt it.
Tip
If you still want to use reserved words enclose them with double quotation marks “”.
This list contains keywords that are reserved for use in Kexi SQL:
AFTER
ALL
ASC
BEFORE
BEGIN
BETWEEN
BY
CASCADE
CASE
CHECK
COLLATE
COMMIT
CONSTRAINT
CROSS
DATABASE
DEFAULT
DELETE
DESC
DISTINCT
DROP
END
ELSE
EXPLAIN
FOR
FOREIGN
FULL
GROUP
HAVING
IGNORE
INDEX
INNER
INSERT
INTO
KEY
LIMIT
MATCH
NATURAL
OFFSET
ORDER
OUTER
PRIMARY
REFERENCES
REPLACE
RESTRICT
ROLLBACK
ROW
SET
TEMPORARY
THEN
TRANSACTION
UNION
UNIQUE
UPDATE
USING
VALUES
WHEN