-- https://modern-sql.com/standard -- https://jakewheat.github.io/sql-overview/ -- https://ronsavage.github.io/SQL/ -- SQL-92 =========================================================== -- https://ronsavage.github.io/SQL/sql-92.bnf -- https://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt -- https://jakewheat.github.io/sql-overview/sql-92-grammar.html --! Data Types =========================================================== -- character string type CHARACTER CHAR CHARACTER VARYING CHAR VARYING VARCHAR -- national character string type NATIONAL CHARACTER NATIONAL CHAR NCHAR NATIONAL CHARACTER VARYING NATIONAL CHAR VARYING NCHAR VARYING -- bit string type BIT BIT VARYING -- numeric type NUMERIC DECIMAL DEC INTEGER INT SMALLINT FLOAT REAL DOUBLE PRECISION -- datetime type DATE TIME TIMESTAMP YEAR MONTH DAY HOUR MINUTE SECOND -- interval type INTERVAL --! keywords =========================================================== -- reserved word ABSOLUTE ACTION ADD ALL ALLOCATE ALTER AND ANY ARE AS ASC ASSERTION AT AUTHORIZATION AVG BEGIN BETWEEN BIT BIT_LENGTH BOTH BY CASCADE CASCADED CASE CAST CATALOG CHAR CHAR_LENGTH CHARACTER CHARACTER_LENGTH CHECK CLOSE COALESCE COLLATE COLLATION COLUMN COMMIT CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONTINUE CONVERT CORRESPONDING CREATE CROSS CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR 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 EXTERNAL EXTRACT FALSE FETCH FIRST FLOAT FOR FOREIGN FOUND FROM FULL GET GLOBAL GO GOTO GRANT GROUP HAVING HOUR IDENTITY IMMEDIATE IN INDICATOR INITIALLY INNER INPUT INSENSITIVE INSERT INT INTEGER INTERSECT INTERVAL INTO IS ISOLATION JOIN KEY LANGUAGE LAST LEADING LEFT LEVEL LIKE LOCAL LOWER MATCH MAX MIN MINUTE MODULE MONTH NAMES NATIONAL NATURAL NCHAR NEXT NO NOT NULL NULLIF NUMERIC OCTET_LENGTH OF ON ONLY OPEN OPTION OR ORDER OUTER OUTPUT OVERLAPS PAD PARTIAL POSITION PRECISION PREPARE PRESERVE PRIMARY PRIOR PRIVILEGES PROCEDURE PUBLIC READ REAL REFERENCES RELATIVE RESTRICT REVOKE RIGHT ROLLBACK ROWS SCHEMA SCROLL SECOND SECTION SELECT SESSION SESSION_USER SET SIZE SMALLINT SOME SPACE SQL SQLCODE SQLERROR SQLSTATE SUBSTRING SUM SYSTEM_USER TABLE TEMPORARY THEN TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TO TRAILING TRANSACTION TRANSLATE TRANSLATION TRIM TRUE UNION UNIQUE UNKNOWN UPDATE UPPER USAGE USER USING VALUE VALUES VARCHAR VARYING VIEW WHEN WHENEVER WHERE WITH WORK WRITE YEAR ZONE -- non-reserved word ADA C CATALOG_NAME CHARACTER_SET_CATALOG CHARACTER_SET_NAME CHARACTER_SET_SCHEMA CLASS_ORIGIN COBOL COLLATION_CATALOG COLLATION_NAME COLLATION_SCHEMA COLUMN_NAME COMMAND_FUNCTION COMMITTED CONDITION_NUMBER CONNECTION_NAME CONSTRAINT_CATALOG CONSTRAINT_NAME CONSTRAINT_SCHEMA CURSOR_NAME DATA DATETIME_INTERVAL_CODE DATETIME_INTERVAL_PRECISION DYNAMIC_FUNCTION FORTRAN LENGTH MESSAGE_LENGTH MESSAGE_OCTET_LENGTH MESSAGE_TEXT MORE MUMPS NAME NULLABLE NUMBER PASCAL PLI REPEATABLE RETURNED_LENGTH RETURNED_OCTET_LENGTH RETURNED_SQLSTATE ROW_COUNT SCALE SCHEMA_NAME SERIALIZABLE SERVER_NAME SUBCLASS_ORIGIN TABLE_NAME TYPE UNCOMMITTED UNNAMED -- SQL:1999 =========================================================== -- https://ronsavage.github.io/SQL/sql-99.bnf -- https://jakewheat.github.io/sql-overview/sql-1999-grammar.html --! Data Types =========================================================== -- character string type CHARACTER CHAR CHARACTER VARYING CHAR VARYING VARCHAR CHARACTER LARGE OBJECT CHAR LARGE OBJECT CLOB -- national character string type NATIONAL CHARACTER NATIONAL CHAR NCHAR NATIONAL CHARACTER VARYING NATIONAL CHAR VARYING NCHAR VARYING NATIONAL CHARACTER LARGE OBJECT NCHAR LARGE OBJECT NCLOB -- binary large object string type BINARY LARGE OBJECT BLOB -- bit string type BIT BIT VARYING -- numeric type NUMERIC DECIMAL DEC INTEGER INT SMALLINT FLOAT REAL DOUBLE PRECISION BOOLEAN -- datetime type DATE TIME TIMESTAMP YEAR MONTH DAY HOUR MINUTE SECOND -- interval type INTERVAL -- row type ROW --