SQL_SyntaxChecker

Purpose:

This project allows real-time checking of SQL Syntax.

This syntax checking includes Coloration of numbers, quotation marks, brackets, and Reserved Words as well as capitilization of Reserved Words.

Currently the Reserved Words are as Follows:

(Click to expand)

"ABORT", "ACCELERATED", "ADD", "AFTER", "ALL", "ALTER", "AND", "ANSI-PADDING", "ANY", "AS", "ASC", "ATOMIC", "AVG", "BEFORE", "BEGIN", "BETWEEN", "BORDER", "BY", "CALL", "CACHED_PROCEDURES", "CASCADE", "CASE", "CAST", "CHECK", "CLOSE", "COALESCE", "COLLATE", "COLUMN", "COMMIT", "COMMITTED", "CONSTRAINT", "CONVERT", "COUNT", "CREATE", "CREATESP", "CREATETAB", "CREATEVIEW", "CROSS", "CS", "CURDATE", "CURRENT", "CURSOR", "CURTIME", "DATA_PATH", "DATABASE", "DATETIMEMILLISECONDS", "DBO", "DBSEC_AUTHENTICATION", "DBSEC_AUTHORIZATION", "DCOMPRESS", "DDF", "DECIMALSEPARATORCOMMA", "DECLARE", "DEFAULT", "DEFAULTCOLLATE", "DELETE", "DENY", "DESC", "DIAGNOSTICS", "DICTIONARY", "DICTIONARY_PATH", "DISTINCT", "DO", "DROP", "DSN", "EACH", "ELSE", "ENCODING", "END", "ENFORCED", "EX", "EXCLUSIVE", "EXEC", "EXECUTE", "EXISTING", "EXISTS", "EXPR", "FETCH", "FILES", "FN", "FOR", "FOREIGN", "FROM", "FULL", "FUNCTION", "", "GLOBAL_QRYPLAN", "GRANT", "GROUP", "HANDLER", "HAVING", "IF", "IN", "INDEX", "INNER", "INOUT", "INSERT", "INTEGRITY", "INTERNAL", "INTO", "IS", "ISOLATION", "JOIN", "KEY", "LEAVE", "LEFT", "LEGACYOWNERNAME", "LEVEL", "LIKE", "LIMIT", "LINKDUP", "LOGIN", "LOOP", "NEW", "NEXT", "NO", "NO_REFERENTIAL_INTEGRITY", "NORMAL", "NOT", "NOW", "NULL", "OF", "OFF", "OFFSET", "OLD", "ON", "ONLY", "OPEN", "OPTINNERJOIN", "OR", "ORDER", "OUT", "OUTER", "OWNER", "PAGESIZE", "PARTIAL", "PASSWORD", "PCOMPRESS", "PRED", "PRIMARY", "PRINT", "PROCEDURE", "PROCEDURES_CACHE", "PSQL_MOVE", "PSQL_PHYSICAL", "PSQL_POSITION", "PUBLIC", "QRYPLAN", "QRYPLANOUTPUT", "READ", "REFERENCES", "REFERENCING", "RELATIONAL", "RELEASE", "RENAME", "REPEAT", "REPEATABLE", "REPLACE", "RESTRICT", "RETURN", "RETURNS", "REUSE_DDF", "REVERSE", "REVOKE", "RIGHT", "ROLLBACK", "ROW", "ROWCOUNT", "ROWCOUNT2", "SAVEPOINT", "SECURITY", "SELECT", "SERIALIZABLE", "SESSIONID", "SET", "SIGNAL", "SIZE", "SPID", "SQLSTATE", "SSP_EXPR", "SSP_PRED", "START", "STDEV", "SUM", "SVBEGIN", "SVEND", "T", "TABLE", "THEN", "TO", "TOP", "TRANSACTION", "TRIGGER", "TRIGGERSTAMPMISC", "TRUEBITCREATE", "TRUENULLCREATE", "TRY_CAST", "TS", "UNCOMMITTED", "UNION", "UNIQUE", "UNIQUEIDENTIFIER", "UNTIL", "UPDATE", "USER", "USING", "V1_METADATA", "V2_METADATA", "VALUES", "VIEW", "WHEN", "WHERE", "WHILE", "WITH", "WORK", "WRITE", "ABSOLUTE", "ACTION", "ADD", "ALL", "ALLOCATE", "ALTER", "AND", "ANY", "ARE", "AS", "ASC", "ASSERTION", "AT", "AUTHORIZATION", "AVG", "BEGIN", "BETWEEN", "BIGIDENTITY", "BIT", "BIT_LENGTH", "BOTH", "BY", "CASCADE", "CASCADED", "CASE", "CAST", "CATALOG", "CHAR", "CHARACTER", "CHAR_LENGTH", "CHARACTER_LENGTH", "CHECK", "CLOSE", "COALESCE", "COLLATE", "COLLATION", "COLUMN", "COMMIT", "CONNECT", "CONNECTION", "CONSTRAINT", "CONSTRAINTS", "CONTINUE", "CONVERT", "CORRESPONDING", "COUNT", "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", "FUNCTION", "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", "LIMIT", "LOCAL", "LOWER", "MASK", "MATCH", "MAX", "MIN", "MINUTE", "MODULE", "MONTH", "NAMES", "NATIONAL", "NATURAL", "NCHAR", "NEXT", "NO", "NOT", "NLONGVARCHAR", "NULL", "NULLIF", "NUMERIC", "NVARCHAR", "OCTET_LENGTH", "OF", "OFFSET", "ON", "ONLY", "OPEN", "OPTION", "OR", "ORDER", "OUTER", "OUTPUT", "OVERLAPS", "PAD", "PARTIAL", "PASSWORD", "POSITION", "PRECISION", "PREPARE", "PRESERVE", "PRIMARY", "PRIOR", "PRIVILEGES", "PROCEDURE", "PUBLIC", "READ", "REAL", "REFERENCES", "RELATIVE", "RESTRICT", "REVERSE", "REVOKE", "RIGHT", "ROLLBACK", "ROWS", "SCHEMA", "SCROLL", "SECOND", "SECTION", "SELECT", "SESSION", "SESSION_USER", "SET", "SIZE", "SMALLIDENTITY", "SMALLINT", "SOME", "SPACE", "SQL", "SQLCODE", "SQLERROR", "SQLSTATE", "STDEV", "SUBSTRING", "SUM", "SYSTEM_USER", "TABLE", "TEMPORARY", "THEN", "TIME", "TIMESTAMP", "TIMEZONE_HOUR", "TIMEZONE_MINUTE", "TO", "TRAILING", "TRANSACTION", "TRANSLATE", "TRANSLATION", "TRIM", "TRUE", "TRY_CAST", "UNION", "UNIQUE", "UNKNOWN", "UPDATE", "UPPER", "USAGE", "USER", "USING", "VALUE", "VALUES", "VARCHAR", "VARYING", "VIEW", "WHEN", "WHENEVER", "WHERE", "WITH", "WORK", "WRITE", "YEAR", "ZONE"