OS/2 Shareware BBS: InfoMgt

home *** CD-ROM | disk | FTP | other *** search

/ OS/2 Shareware BBS: InfoMgt / InfoMgt.zip / dbup208.zip / SQLWORDS.TXT < prev

Wrap

Text File | 1998-02-11 | 7KB | 338 lines

This following list includes the SQL keywords defined in the ISO/ANS SQL92 standard plus additional words reserved in various dialects of SQL used by different database products. To preserve the portability of data between database systems, these words should not be used as table or column names. ABSOLUTE ACQUIRE ACTION ADA ADD ALL ALLOCATE ALTER AND ANY ARE AS ASC ASSERTION AT AUDIT AUTHORIZATION AVG BEGIN BETWEEN BIT BIT_LENGTH BOTH BUFFERPOOL BY CALL CAPTURE CASCADED CASE CAST CATALOG CCSID CHAR CHAR_LENGTH CHARACTER CHARACTER_LENGTH CHECK CLOSE CLUSTER COALASCE COLLATE COLLATION COLLECTION COLUMN COMMENT COMMIT CONCAT CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONTINUE CONVERT CORRESPONDING COUNT CREATE CROSS CURRENT CURRENT_DATE CURRENT_SERVER CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TIMEZONE CURRENT_USER CURSOR DATABASE DATE DAY DAYS DBA DBSPACE DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DESC DESCRIBE DESCRIPTOR DIAGNOSTICS DISCONNECT DISTINCT DOMAIN DOUBLE DROP EDITPROC ELSE END END-EXEC ERASE ESCAPE EXCEPT EXCEPTION EXCLUSIVE EXEC EXECUTE EXISTS EXPLAIN EXTERNAL EXTRACT FALSE FETCH FIELDPROC FIRST FLOAT FOR FOREIGN FORTRAN FOUND FROM FULL GET GLOBAL GO GOTO GRANT GRAPHIC GROUP HAVING HOUR HOURS IDENTIFIED IDENTITY IMMEDIATE IN INDEX INDICATOR INITIALLY INNER INOUT INPUT INSENSITIVE INSERT INT INTEGER INTERSECT INTERVAL INTO IS ISOLATION JOIN KEY LABEL LANGUAGE LAST LEADING LEFT LEVEL LIKE LOCAL LOCK LOCKSIZE LONG LOWER MATCH MAX MICROSECOND MICROSECONDS MIN MINUTE MINUTES MODE MODULE MONTH MONTHS NAMED NAMES NATIONAL NATURAL NCHAR NEXT NHEADER NO NONE NOT NULL NULLIF NUMERIC NUMPARTS OBID OCTET_LENGTH OF ON ONLY OPEN OPTIMIZE OPTION OPTIONS OR ORDER OUT OUTER OUTPUT OVERLAPS PACKAGE PAD PAGE PAGES PART PARTIAL PASCAL PCTFREE PCTINDEX PLAN POSITION PRECISION PREPARE PRESERVE PRIMARY PRIOR PRIQTY PRIVATE PRIVILEGES PROCEDURE PROGRAM PUBLIC READ REAL REFERENCES RELATIVE RELEASE RESET RESOURCE RESTRICT REVOKE RIGHT ROLLBACK ROW ROWS RRN RUN SCHEDULE SCHEMA SCROLL SECOND SECONDS SECQTY SECTION SELECT SESSION SESSION_USER SET SHARE SIMPLE SIZE SMALLINT SOME SPACE SQL SQLCA SQLCODE SQLERROR SQLSTATE SQLWARNING STATISTICS STOGROUP STORPOOL SUBPAGES SUBSTRING SUM SYNONYM SYSTEM_USER TABLE TABLESPACE TEMPORARY THEN TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TO TRAILING TRANSACTION TRANSLATION TRIM TRUE UNION UNIQUE UNKNOWN UPDATE UPPER USAGE USER USING VALIDPROC VALUE VALUES VARCHAR VARIABLE VARYING VCAT VIEW VOLUMES WHEN WHENEVER WHERE WITH WORK WRITE YEAR YEARS ZONE