|
<< Click to Display Table of Contents >> SQL Reserved Words |
  
|
SQL Reserved Words
|
<< Click to Display Table of Contents >> SQL Reserved Words |
|
Reserved Words
The words reserved in SQL of the Absolute Database are listed below.
If you use a reserved word for table name, column or index name, you must enclose the name in square brackets to use it in any SQL statement.
ABS ABSOLUTE ACOS ACTION ADD ALL ALLOCATE ALTER AND ANY ARE AS ASC ASIN ASSERTION AT ATAN AUTHORIZATION AUTOINC AUTOINDEXES AVG BEGIN BETWEEN BIT BIT_LENGTH BLOBBLOCKSIZE BLOBCOMPRESSIONALGORITHM BLOBCOMPRESSIONMODE BOTH BY CASCADE CASCADED CASE CAST CATALOG CEIL CHAR CHAR_LENGTH CHARACTER CHARACTER_LENGTH CHECK CLOSE COALESCE COLLATE COLLATION COLUMN COMMIT CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONTINUE CONVERT CORRESPONDING COS COUNT CREATE CROSS CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CYCLED DATE DAY DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DESC DESCRIBE DESCRIPTOR DIAGNOSTICS DISCONNECT DISTINCT DOMAIN DOUBLE DROP ELSE END END-EXEC ESCAPE EXCEPT EXCEPTION EXEC EXECUTE EXISTS EXP EXTERNAL EXTRACT |
FALSE FETCH FIRST FLOAT FLOOR FLUSH FOR FOREIGN FOUND FROM FULL GET GLOBAL GO GOTO GRANT GROUP HAVING HOUR IDENTITY IF IMMEDIATE IN INCREMENT INDEX INDICATOR INITIALLY INITIALVALUE INNER INPUT INSENSITIVE INSERT INT INTEGER INTERSECT INTERVAL INTO IS ISOLATION JOIN KEY LANGUAGE LAST LASTAUTOINC LASTVALUE LEADING LEFT LENGTH LEVEL LIKE LOCAL LOG LOWER LTRIM MATCH MAX MAXVALUE MEMORY MIMETOBIN MIN MINUS MINUTE MINVALUE MODIFY MODULE MONTH NAMES NATIONAL NATURAL NCHAR NEW NEXT NO NOAUTOINDEXES NOCASE NOCYCLED NOMAXVALUE NOMINVALUE NOT NOW NULL NULLIF NUMERIC OCTET_LENGTH OF ON ONLY OPEN OPTION OR ORDER OUTER OUTPUT OVERLAPS |
PAD PARTIAL PASSWORD POS POSITION POWER PRECISION PREPARE PRESERVE PRIMARY PRIOR PRIVILEGES PROCEDURE PUBLIC RAND READ REAL REFERENCES RELATIVE RENAME RESTRICT REVOKE RIGHT ROLLBACK ROUND ROWNUM ROWS RTRIM SCHEMA SCROLL SECOND SECTION SELECT SESSION SESSION_USER SET SIGN SIN SIZE SMALLINT SOME SPACE SQL SQLCODE SQLERROR SQLSTATE SQR SQRT START SUBSTRING SUM SYSDATE SYSTEM_USER TABLE TEMPORARY THEN TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TO TODATE TOP TOSTRING TRAILING TRANSACTION TRANSLATE TRANSLATION TRIM TRUE TRUNCATE UNION UNIQUE UNKNOWN UPDATE UPPER USAGE USER USING VALUE VALUES VARCHAR VARYING VIEW WHEN WHENEVER WHERE WITH WORK WRITE YEAR ZONE |
_____________________________
27-10-2017 - Niels Knabe