/* * RapidMiner * * Copyright (C) 2001-2008 by Rapid-I and the contributors * * Complete list of developers available at our web site: * * http://rapid-i.com * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see http://www.gnu.org/licenses/. */ package com.rapidminer.gui.tools.syntax; /* * TSQLTokenMarker.java - Transact-SQL token marker * Copyright (C) 1999 mike dillon * * You may use and modify this package for any purpose. Redistribution is * permitted, in both source and binary form, provided that this notice * remains intact in all source distributions of this package. */ /** * Transact-SQL token marker. * * @author Mike Dillon, Ingo Mierswa * @version $Id: TSQLTokenMarker.java,v 1.3 2008/05/09 19:22:57 ingomierswa Exp $ */ public class TSQLTokenMarker extends SQLTokenMarker { // public members public TSQLTokenMarker() { super(getKeywordMap(), true); } public static KeywordMap getKeywordMap() { if (tsqlKeywords == null) { tsqlKeywords = new KeywordMap(true); addKeywords(); addDataTypes(); addSystemFunctions(); addOperators(); addSystemStoredProcedures(); addSystemTables(); } return tsqlKeywords; } private static void addKeywords() { tsqlKeywords.add("ADD", Token.KEYWORD1); tsqlKeywords.add("ALTER", Token.KEYWORD1); tsqlKeywords.add("ANSI_NULLS", Token.KEYWORD1); tsqlKeywords.add("AS", Token.KEYWORD1); tsqlKeywords.add("ASC", Token.KEYWORD1); tsqlKeywords.add("AUTHORIZATION", Token.KEYWORD1); tsqlKeywords.add("BACKUP", Token.KEYWORD1); tsqlKeywords.add("BEGIN", Token.KEYWORD1); tsqlKeywords.add("BREAK", Token.KEYWORD1); tsqlKeywords.add("BROWSE", Token.KEYWORD1); tsqlKeywords.add("BULK", Token.KEYWORD1); tsqlKeywords.add("BY", Token.KEYWORD1); tsqlKeywords.add("CASCADE", Token.KEYWORD1); tsqlKeywords.add("CHECK", Token.KEYWORD1); tsqlKeywords.add("CHECKPOINT", Token.KEYWORD1); tsqlKeywords.add("CLOSE", Token.KEYWORD1); tsqlKeywords.add("CLUSTERED", Token.KEYWORD1); tsqlKeywords.add("COLUMN", Token.KEYWORD1); tsqlKeywords.add("COMMIT", Token.KEYWORD1); tsqlKeywords.add("COMMITTED", Token.KEYWORD1); tsqlKeywords.add("COMPUTE", Token.KEYWORD1); tsqlKeywords.add("CONFIRM", Token.KEYWORD1); tsqlKeywords.add("CONSTRAINT", Token.KEYWORD1); tsqlKeywords.add("CONTAINS", Token.KEYWORD1); tsqlKeywords.add("CONTAINSTABLE", Token.KEYWORD1); tsqlKeywords.add("CONTINUE", Token.KEYWORD1); tsqlKeywords.add("CONTROLROW", Token.KEYWORD1); tsqlKeywords.add("CREATE", Token.KEYWORD1); tsqlKeywords.add("CURRENT", Token.KEYWORD1); tsqlKeywords.add("CURRENT_DATE", Token.KEYWORD1); tsqlKeywords.add("CURRENT_TIME", Token.KEYWORD1); tsqlKeywords.add("CURSOR", Token.KEYWORD1); tsqlKeywords.add("DATABASE", Token.KEYWORD1); tsqlKeywords.add("DBCC", Token.KEYWORD1); tsqlKeywords.add("DEALLOCATE", Token.KEYWORD1); tsqlKeywords.add("DECLARE", Token.KEYWORD1); tsqlKeywords.add("DEFAULT", Token.KEYWORD1); tsqlKeywords.add("DELETE", Token.KEYWORD1); tsqlKeywords.add("DENY", Token.KEYWORD1); tsqlKeywords.add("DESC", Token.KEYWORD1); tsqlKeywords.add("DISK", Token.KEYWORD1); tsqlKeywords.add("DISTINCT", Token.KEYWORD1); tsqlKeywords.add("DISTRIBUTED", Token.KEYWORD1); tsqlKeywords.add("DOUBLE", Token.KEYWORD1); tsqlKeywords.add("DROP", Token.KEYWORD1); tsqlKeywords.add("DUMMY", Token.KEYWORD1); tsqlKeywords.add("DUMP", Token.KEYWORD1); tsqlKeywords.add("ELSE", Token.KEYWORD1); tsqlKeywords.add("END", Token.KEYWORD1); tsqlKeywords.add("ERRLVL", Token.KEYWORD1); tsqlKeywords.add("ERROREXIT", Token.KEYWORD1); tsqlKeywords.add("ESCAPE", Token.KEYWORD1); tsqlKeywords.add("EXCEPT", Token.KEYWORD1); tsqlKeywords.add("EXEC", Token.KEYWORD1); tsqlKeywords.add("EXECUTE", Token.KEYWORD1); tsqlKeywords.add("EXIT", Token.KEYWORD1); tsqlKeywords.add("FETCH", Token.KEYWORD1); tsqlKeywords.add("FILE", Token.KEYWORD1); tsqlKeywords.add("FILLFACTOR", Token.KEYWORD1); tsqlKeywords.add("FLOPPY", Token.KEYWORD1); tsqlKeywords.add("FOR", Token.KEYWORD1); tsqlKeywords.add("FOREIGN", Token.KEYWORD1); tsqlKeywords.add("FREETEXT", Token.KEYWORD1); tsqlKeywords.add("FREETEXTTABLE", Token.KEYWORD1); tsqlKeywords.add("FROM", Token.KEYWORD1); tsqlKeywords.add("FULL", Token.KEYWORD1); tsqlKeywords.add("GOTO", Token.KEYWORD1); tsqlKeywords.add("GRANT", Token.KEYWORD1); tsqlKeywords.add("GROUP", Token.KEYWORD1); tsqlKeywords.add("HAVING", Token.KEYWORD1); tsqlKeywords.add("HOLDLOCK", Token.KEYWORD1); tsqlKeywords.add("IDENTITY_INSERT", Token.KEYWORD1); tsqlKeywords.add("IDENTITYCOL", Token.KEYWORD1); tsqlKeywords.add("ID", Token.KEYWORD1); tsqlKeywords.add("IF", Token.KEYWORD1); tsqlKeywords.add("INDEX", Token.KEYWORD1); tsqlKeywords.add("INNER", Token.KEYWORD1); tsqlKeywords.add("INSERT", Token.KEYWORD1); tsqlKeywords.add("INTO", Token.KEYWORD1); tsqlKeywords.add("IS", Token.KEYWORD1); tsqlKeywords.add("ISOLATION", Token.KEYWORD1); tsqlKeywords.add("KEY", Token.KEYWORD1); tsqlKeywords.add("KILL", Token.KEYWORD1); tsqlKeywords.add("LEVEL", Token.KEYWORD1); tsqlKeywords.add("LINENO", Token.KEYWORD1); tsqlKeywords.add("LOAD", Token.KEYWORD1); tsqlKeywords.add("MAX", Token.KEYWORD1); tsqlKeywords.add("MIN", Token.KEYWORD1); tsqlKeywords.add("MIRROREXIT", Token.KEYWORD1); tsqlKeywords.add("NATIONAL", Token.KEYWORD1); tsqlKeywords.add("NOCHECK", Token.KEYWORD1); tsqlKeywords.add("NONCLUSTERED", Token.KEYWORD1); tsqlKeywords.add("OF", Token.KEYWORD1); tsqlKeywords.add("OFF", Token.KEYWORD1); tsqlKeywords.add("OFFSETS", Token.KEYWORD1); tsqlKeywords.add("ON", Token.KEYWORD1); tsqlKeywords.add("ONCE", Token.KEYWORD1); tsqlKeywords.add("ONLY", Token.KEYWORD1); tsqlKeywords.add("OPEN", Token.KEYWORD1); tsqlKeywords.add("OPENDATASOURCE", Token.KEYWORD1); tsqlKeywords.add("OPENQUERY", Token.KEYWORD1); tsqlKeywords.add("OPENROWSET", Token.KEYWORD1); tsqlKeywords.add("OPTION", Token.KEYWORD1); tsqlKeywords.add("ORDER", Token.KEYWORD1); tsqlKeywords.add("OVER", Token.KEYWORD1); tsqlKeywords.add("PERCENT", Token.KEYWORD1); tsqlKeywords.add("PERM", Token.KEYWORD1); tsqlKeywords.add("PERMANENT", Token.KEYWORD1); tsqlKeywords.add("PIPE", Token.KEYWORD1); tsqlKeywords.add("PLAN", Token.KEYWORD1); tsqlKeywords.add("PRECISION", Token.KEYWORD1); tsqlKeywords.add("PREPARE", Token.KEYWORD1); tsqlKeywords.add("PRIMARY", Token.KEYWORD1); tsqlKeywords.add("PRINT", Token.KEYWORD1); tsqlKeywords.add("PRIVILEGES", Token.KEYWORD1); tsqlKeywords.add("PROC", Token.KEYWORD1); tsqlKeywords.add("PROCEDURE", Token.KEYWORD1); tsqlKeywords.add("PROCESSEXIT", Token.KEYWORD1); tsqlKeywords.add("PUBLIC", Token.KEYWORD1); tsqlKeywords.add("QUOTED_IDENTIFIER", Token.KEYWORD1); tsqlKeywords.add("RAISERROR", Token.KEYWORD1); tsqlKeywords.add("READ", Token.KEYWORD1); tsqlKeywords.add("READTEXT", Token.KEYWORD1); tsqlKeywords.add("RECONFIGURE", Token.KEYWORD1); tsqlKeywords.add("REFERENCES", Token.KEYWORD1); tsqlKeywords.add("REPEATABLE", Token.KEYWORD1); tsqlKeywords.add("REPLICATION", Token.KEYWORD1); tsqlKeywords.add("RESTORE", Token.KEYWORD1); tsqlKeywords.add("RESTRICT", Token.KEYWORD1); tsqlKeywords.add("RETURN", Token.KEYWORD1); tsqlKeywords.add("REVOKE", Token.KEYWORD1); tsqlKeywords.add("ROLLBACK", Token.KEYWORD1); tsqlKeywords.add("ROWGUIDCOL", Token.KEYWORD1); tsqlKeywords.add("RULE", Token.KEYWORD1); tsqlKeywords.add("SAVE", Token.KEYWORD1); tsqlKeywords.add("SCHEMA", Token.KEYWORD1); tsqlKeywords.add("SELECT", Token.KEYWORD1); tsqlKeywords.add("SERIALIZABLE", Token.KEYWORD1); tsqlKeywords.add("SET", Token.KEYWORD1); tsqlKeywords.add("SETUSER", Token.KEYWORD1); tsqlKeywords.add("SHUTDOWN", Token.KEYWORD1); tsqlKeywords.add("STATISTICS", Token.KEYWORD1); tsqlKeywords.add("TABLE", Token.KEYWORD1); tsqlKeywords.add("TAPE", Token.KEYWORD1); tsqlKeywords.add("TEMP", Token.KEYWORD1); tsqlKeywords.add("TEMPORARY", Token.KEYWORD1); tsqlKeywords.add("TEXTIMAGE_ON", Token.KEYWORD1); tsqlKeywords.add("THEN", Token.KEYWORD1); tsqlKeywords.add("TO", Token.KEYWORD1); tsqlKeywords.add("TOP", Token.KEYWORD1); tsqlKeywords.add("TRAN", Token.KEYWORD1); tsqlKeywords.add("TRANSACTION", Token.KEYWORD1); tsqlKeywords.add("TRIGGER", Token.KEYWORD1); tsqlKeywords.add("TRUNCATE", Token.KEYWORD1); tsqlKeywords.add("TSEQUAL", Token.KEYWORD1); tsqlKeywords.add("UNCOMMITTED", Token.KEYWORD1); tsqlKeywords.add("UNION", Token.KEYWORD1); tsqlKeywords.add("UNIQUE", Token.KEYWORD1); tsqlKeywords.add("UPDATE", Token.KEYWORD1); tsqlKeywords.add("UPDATETEXT", Token.KEYWORD1); tsqlKeywords.add("USE", Token.KEYWORD1); tsqlKeywords.add("VALUES", Token.KEYWORD1); tsqlKeywords.add("VARYING", Token.KEYWORD1); tsqlKeywords.add("VIEW", Token.KEYWORD1); tsqlKeywords.add("WAITFOR", Token.KEYWORD1); tsqlKeywords.add("WHEN", Token.KEYWORD1); tsqlKeywords.add("WHERE", Token.KEYWORD1); tsqlKeywords.add("WHILE", Token.KEYWORD1); tsqlKeywords.add("WITH", Token.KEYWORD1); tsqlKeywords.add("WORK", Token.KEYWORD1); tsqlKeywords.add("WRITETEXT", Token.KEYWORD1); } private static void addDataTypes() { tsqlKeywords.add("binary", Token.KEYWORD1); tsqlKeywords.add("bit", Token.KEYWORD1); tsqlKeywords.add("char", Token.KEYWORD1); tsqlKeywords.add("character", Token.KEYWORD1); tsqlKeywords.add("datetime", Token.KEYWORD1); tsqlKeywords.add("decimal", Token.KEYWORD1); tsqlKeywords.add("float", Token.KEYWORD1); tsqlKeywords.add("image", Token.KEYWORD1); tsqlKeywords.add("int", Token.KEYWORD1); tsqlKeywords.add("integer", Token.KEYWORD1); tsqlKeywords.add("money", Token.KEYWORD1); tsqlKeywords.add("name", Token.KEYWORD1); tsqlKeywords.add("numeric", Token.KEYWORD1); tsqlKeywords.add("nchar", Token.KEYWORD1); tsqlKeywords.add("nvarchar", Token.KEYWORD1); tsqlKeywords.add("ntext", Token.KEYWORD1); tsqlKeywords.add("real", Token.KEYWORD1); tsqlKeywords.add("smalldatetime", Token.KEYWORD1); tsqlKeywords.add("smallint", Token.KEYWORD1); tsqlKeywords.add("smallmoney", Token.KEYWORD1); tsqlKeywords.add("text", Token.KEYWORD1); tsqlKeywords.add("timestamp", Token.KEYWORD1); tsqlKeywords.add("tinyint", Token.KEYWORD1); tsqlKeywords.add("uniqueidentifier", Token.KEYWORD1); tsqlKeywords.add("varbinary", Token.KEYWORD1); tsqlKeywords.add("varchar", Token.KEYWORD1); } private static void addSystemFunctions() { tsqlKeywords.add("@@CONNECTIONS", Token.KEYWORD2); tsqlKeywords.add("@@CPU_BUSY", Token.KEYWORD2); tsqlKeywords.add("@@CURSOR_ROWS", Token.KEYWORD2); tsqlKeywords.add("@@DATEFIRST", Token.KEYWORD2); tsqlKeywords.add("@@DBTS", Token.KEYWORD2); tsqlKeywords.add("@@ERROR", Token.KEYWORD2); tsqlKeywords.add("@@FETCH_STATUS", Token.KEYWORD2); tsqlKeywords.add("@@IDENTITY", Token.KEYWORD2); tsqlKeywords.add("@@IDLE", Token.KEYWORD2); tsqlKeywords.add("@@IO_BUSY", Token.KEYWORD2); tsqlKeywords.add("@@LANGID", Token.KEYWORD2); tsqlKeywords.add("@@LANGUAGE", Token.KEYWORD2); tsqlKeywords.add("@@LOCK_TIMEOUT", Token.KEYWORD2); tsqlKeywords.add("@@MAX_CONNECTIONS", Token.KEYWORD2); tsqlKeywords.add("@@MAX_PRECISION", Token.KEYWORD2); tsqlKeywords.add("@@NESTLEVEL", Token.KEYWORD2); tsqlKeywords.add("@@OPTIONS", Token.KEYWORD2); tsqlKeywords.add("@@PACK_RECEIVED", Token.KEYWORD2); tsqlKeywords.add("@@PACK_SENT", Token.KEYWORD2); tsqlKeywords.add("@@PACKET_ERRORS", Token.KEYWORD2); tsqlKeywords.add("@@PROCID", Token.KEYWORD2); tsqlKeywords.add("@@REMSERVER", Token.KEYWORD2); tsqlKeywords.add("@@ROWCOUNT", Token.KEYWORD2); tsqlKeywords.add("@@SERVERNAME", Token.KEYWORD2); tsqlKeywords.add("@@SERVICENAME", Token.KEYWORD2); tsqlKeywords.add("@@SPID", Token.KEYWORD2); tsqlKeywords.add("@@TEXTSIZE", Token.KEYWORD2); tsqlKeywords.add("@@TIMETICKS", Token.KEYWORD2); tsqlKeywords.add("@@TOTAL_ERRORS", Token.KEYWORD2); tsqlKeywords.add("@@TOTAL_READ", Token.KEYWORD2); tsqlKeywords.add("@@TOTAL_WRITE", Token.KEYWORD2); tsqlKeywords.add("@@TRANCOUNT", Token.KEYWORD2); tsqlKeywords.add("@@VERSION", Token.KEYWORD2); tsqlKeywords.add("ABS", Token.KEYWORD2); tsqlKeywords.add("ACOS", Token.KEYWORD2); tsqlKeywords.add("APP_NAME", Token.KEYWORD2); tsqlKeywords.add("ASCII", Token.KEYWORD2); tsqlKeywords.add("ASIN", Token.KEYWORD2); tsqlKeywords.add("ATAN", Token.KEYWORD2); tsqlKeywords.add("ATN2", Token.KEYWORD2); tsqlKeywords.add("CASE", Token.KEYWORD2); tsqlKeywords.add("CAST", Token.KEYWORD2); tsqlKeywords.add("CEILING", Token.KEYWORD2); // tsqlKeywords.add("CHAR",Token.KEYWORD2); tsqlKeywords.add("CHARINDEX", Token.KEYWORD2); tsqlKeywords.add("COALESCE", Token.KEYWORD2); tsqlKeywords.add("COL_LENGTH", Token.KEYWORD2); tsqlKeywords.add("COL_NAME", Token.KEYWORD2); tsqlKeywords.add("COLUMNPROPERTY", Token.KEYWORD2); tsqlKeywords.add("CONVERT", Token.KEYWORD2); tsqlKeywords.add("COS", Token.KEYWORD2); tsqlKeywords.add("COT", Token.KEYWORD2); tsqlKeywords.add("CURRENT_TIME", Token.KEYWORD2); tsqlKeywords.add("CURRENT_DATE", Token.KEYWORD2); tsqlKeywords.add("CURRENT_TIMESTAMP", Token.KEYWORD2); tsqlKeywords.add("CURRENT_USER", Token.KEYWORD2); tsqlKeywords.add("CURSOR_STATUS", Token.KEYWORD2); tsqlKeywords.add("DATABASEPROPERTY", Token.KEYWORD2); tsqlKeywords.add("DATALENGTH", Token.KEYWORD2); tsqlKeywords.add("DATEADD", Token.KEYWORD2); tsqlKeywords.add("DATEDIFF", Token.KEYWORD2); tsqlKeywords.add("DATENAME", Token.KEYWORD2); tsqlKeywords.add("DATEPART", Token.KEYWORD2); tsqlKeywords.add("DAY", Token.KEYWORD2); tsqlKeywords.add("DB_ID", Token.KEYWORD2); tsqlKeywords.add("DB_NAME", Token.KEYWORD2); tsqlKeywords.add("DEGREES", Token.KEYWORD2); tsqlKeywords.add("DIFFERENCE", Token.KEYWORD2); tsqlKeywords.add("EXP", Token.KEYWORD2); tsqlKeywords.add("FILE_ID", Token.KEYWORD2); tsqlKeywords.add("FILE_NAME", Token.KEYWORD2); tsqlKeywords.add("FILEGROUP_ID", Token.KEYWORD2); tsqlKeywords.add("FILEGROUP_NAME", Token.KEYWORD2); tsqlKeywords.add("FILEGROUPPROPERTY", Token.KEYWORD2); tsqlKeywords.add("FILEPROPERTY", Token.KEYWORD2); tsqlKeywords.add("FLOOR", Token.KEYWORD2); tsqlKeywords.add("FORMATMESSAGE", Token.KEYWORD2); tsqlKeywords.add("FULLTEXTCATALOGPROPERTY", Token.KEYWORD2); tsqlKeywords.add("FULLTEXTSERVICEPROPERTY", Token.KEYWORD2); tsqlKeywords.add("GETANSINULL", Token.KEYWORD2); tsqlKeywords.add("GETDATE", Token.KEYWORD2); tsqlKeywords.add("HOST_ID", Token.KEYWORD2); tsqlKeywords.add("HOST_NAME", Token.KEYWORD2); tsqlKeywords.add("IDENT_INCR", Token.KEYWORD2); tsqlKeywords.add("IDENT_SEED", Token.KEYWORD2); // tsqlKeywords.add("IDENTITY",Token.KEYWORD2); tsqlKeywords.add("IDENTITY_INSERT", Token.KEYWORD2); tsqlKeywords.add("INDEX_COL", Token.KEYWORD2); tsqlKeywords.add("INDEXPROPERTY", Token.KEYWORD2); tsqlKeywords.add("IS_MEMBER", Token.KEYWORD2); tsqlKeywords.add("IS_SRVROLEMEMBER", Token.KEYWORD2); tsqlKeywords.add("ISDATE", Token.KEYWORD2); tsqlKeywords.add("ISNULL", Token.KEYWORD2); tsqlKeywords.add("ISNUMERIC", Token.KEYWORD2); tsqlKeywords.add("LEFT", Token.KEYWORD2); tsqlKeywords.add("LEN", Token.KEYWORD2); tsqlKeywords.add("LOG", Token.KEYWORD2); tsqlKeywords.add("LOG10", Token.KEYWORD2); tsqlKeywords.add("LOWER", Token.KEYWORD2); tsqlKeywords.add("LTRIM", Token.KEYWORD2); tsqlKeywords.add("MONTH", Token.KEYWORD2); // tsqlKeywords.add("NCHAR",Token.KEYWORD2); tsqlKeywords.add("NEWID", Token.KEYWORD2); tsqlKeywords.add("NULLIF", Token.KEYWORD2); tsqlKeywords.add("OBJECT_ID", Token.KEYWORD2); tsqlKeywords.add("OBJECT_NAME", Token.KEYWORD2); tsqlKeywords.add("OBJECTPROPERTY", Token.KEYWORD2); tsqlKeywords.add("PARSENAME", Token.KEYWORD2); tsqlKeywords.add("PATINDEX", Token.KEYWORD2); tsqlKeywords.add("PERMISSIONS", Token.KEYWORD2); tsqlKeywords.add("PI", Token.KEYWORD2); tsqlKeywords.add("POWER", Token.KEYWORD2); tsqlKeywords.add("QUOTENAME", Token.KEYWORD2); tsqlKeywords.add("RADIANS", Token.KEYWORD2); tsqlKeywords.add("RAND", Token.KEYWORD2); tsqlKeywords.add("REPLACE", Token.KEYWORD2); tsqlKeywords.add("REPLICATE", Token.KEYWORD2); tsqlKeywords.add("REVERSE", Token.KEYWORD2); tsqlKeywords.add("RIGHT", Token.KEYWORD2); tsqlKeywords.add("ROUND", Token.KEYWORD2); tsqlKeywords.add("RTRIM", Token.KEYWORD2); tsqlKeywords.add("SESSION_USER", Token.KEYWORD2); tsqlKeywords.add("SIGN", Token.KEYWORD2); tsqlKeywords.add("SIN", Token.KEYWORD2); tsqlKeywords.add("SOUNDEX", Token.KEYWORD2); tsqlKeywords.add("SPACE", Token.KEYWORD2); tsqlKeywords.add("SQRT", Token.KEYWORD2); tsqlKeywords.add("SQUARE", Token.KEYWORD2); tsqlKeywords.add("STATS_DATE", Token.KEYWORD2); tsqlKeywords.add("STR", Token.KEYWORD2); tsqlKeywords.add("STUFF", Token.KEYWORD2); tsqlKeywords.add("SUBSTRING", Token.KEYWORD2); tsqlKeywords.add("SUSER_ID", Token.KEYWORD2); tsqlKeywords.add("SUSER_NAME", Token.KEYWORD2); tsqlKeywords.add("SUSER_SID", Token.KEYWORD2); tsqlKeywords.add("SUSER_SNAME", Token.KEYWORD2); tsqlKeywords.add("SYSTEM_USER", Token.KEYWORD2); tsqlKeywords.add("TAN", Token.KEYWORD2); tsqlKeywords.add("TEXTPTR", Token.KEYWORD2); tsqlKeywords.add("TEXTVALID", Token.KEYWORD2); tsqlKeywords.add("TYPEPROPERTY", Token.KEYWORD2); tsqlKeywords.add("UNICODE", Token.KEYWORD2); tsqlKeywords.add("UPPER", Token.KEYWORD2); tsqlKeywords.add("USER_ID", Token.KEYWORD2); tsqlKeywords.add("USER_NAME", Token.KEYWORD2); tsqlKeywords.add("USER", Token.KEYWORD2); tsqlKeywords.add("YEAR", Token.KEYWORD2); } private static void addOperators() { tsqlKeywords.add("ALL", Token.KEYWORD1); tsqlKeywords.add("AND", Token.KEYWORD1); tsqlKeywords.add("ANY", Token.KEYWORD1); tsqlKeywords.add("BETWEEN", Token.KEYWORD1); tsqlKeywords.add("CROSS", Token.KEYWORD1); tsqlKeywords.add("EXISTS", Token.KEYWORD1); tsqlKeywords.add("IN", Token.KEYWORD1); tsqlKeywords.add("INTERSECT", Token.KEYWORD1); tsqlKeywords.add("JOIN", Token.KEYWORD1); tsqlKeywords.add("LIKE", Token.KEYWORD1); tsqlKeywords.add("NOT", Token.KEYWORD1); tsqlKeywords.add("NULL", Token.KEYWORD1); tsqlKeywords.add("OR", Token.KEYWORD1); tsqlKeywords.add("OUTER", Token.KEYWORD1); tsqlKeywords.add("SOME", Token.KEYWORD1); } private static void addSystemStoredProcedures() { tsqlKeywords.add("sp_add_agent_parameter", Token.KEYWORD3); tsqlKeywords.add("sp_add_agent_profile", Token.KEYWORD3); tsqlKeywords.add("sp_add_alert", Token.KEYWORD3); tsqlKeywords.add("sp_add_category", Token.KEYWORD3); tsqlKeywords.add("sp_add_data_file_recover_suspect_db", Token.KEYWORD3); tsqlKeywords.add("sp_add_job", Token.KEYWORD3); tsqlKeywords.add("sp_add_jobschedule", Token.KEYWORD3); tsqlKeywords.add("sp_add_jobserver", Token.KEYWORD3); tsqlKeywords.add("sp_add_jobstep", Token.KEYWORD3); tsqlKeywords.add("sp_add_log_file_recover_suspect_db", Token.KEYWORD3); tsqlKeywords.add("sp_add_notification", Token.KEYWORD3); tsqlKeywords.add("sp_add_operator", Token.KEYWORD3); tsqlKeywords.add("sp_add_targetservergroup", Token.KEYWORD3); tsqlKeywords.add("sp_add_targetsvrgrp_member", Token.KEYWORD3); tsqlKeywords.add("sp_addalias", Token.KEYWORD3); tsqlKeywords.add("sp_addapprole", Token.KEYWORD3); tsqlKeywords.add("sp_addarticle", Token.KEYWORD3); tsqlKeywords.add("sp_adddistpublisher", Token.KEYWORD3); tsqlKeywords.add("sp_adddistributiondb", Token.KEYWORD3); tsqlKeywords.add("sp_adddistributor", Token.KEYWORD3); tsqlKeywords.add("sp_addextendedproc", Token.KEYWORD3); tsqlKeywords.add("sp_addgroup", Token.KEYWORD3); tsqlKeywords.add("sp_addlinkedserver", Token.KEYWORD3); tsqlKeywords.add("sp_addlinkedsrvlogin", Token.KEYWORD3); tsqlKeywords.add("sp_addlinkedsrvlogin", Token.KEYWORD3); tsqlKeywords.add("sp_addlogin", Token.KEYWORD3); tsqlKeywords.add("sp_addmergearticle", Token.KEYWORD3); tsqlKeywords.add("sp_addmergefilter", Token.KEYWORD3); tsqlKeywords.add("sp_addmergepublication", Token.KEYWORD3); tsqlKeywords.add("sp_addmergepullsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_addmergepullsubscription_agent", Token.KEYWORD3); tsqlKeywords.add("sp_addmergesubscription", Token.KEYWORD3); tsqlKeywords.add("sp_addmessage", Token.KEYWORD3); tsqlKeywords.add("sp_addpublication", Token.KEYWORD3); tsqlKeywords.add("sp_addpublication_snapshot", Token.KEYWORD3); tsqlKeywords.add("sp_addpublisher70", Token.KEYWORD3); tsqlKeywords.add("sp_addpullsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_addpullsubscription_agent", Token.KEYWORD3); tsqlKeywords.add("sp_addremotelogin", Token.KEYWORD3); tsqlKeywords.add("sp_addrole", Token.KEYWORD3); tsqlKeywords.add("sp_addrolemember", Token.KEYWORD3); tsqlKeywords.add("sp_addserver", Token.KEYWORD3); tsqlKeywords.add("sp_addsrvrolemember", Token.KEYWORD3); tsqlKeywords.add("sp_addsubscriber", Token.KEYWORD3); tsqlKeywords.add("sp_addsubscriber_schedule", Token.KEYWORD3); tsqlKeywords.add("sp_addsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_addsynctriggers", Token.KEYWORD3); tsqlKeywords.add("sp_addtabletocontents", Token.KEYWORD3); tsqlKeywords.add("sp_addtask", Token.KEYWORD3); tsqlKeywords.add("sp_addtype", Token.KEYWORD3); tsqlKeywords.add("sp_addumpdevice", Token.KEYWORD3); tsqlKeywords.add("sp_adduser", Token.KEYWORD3); tsqlKeywords.add("sp_altermessage", Token.KEYWORD3); tsqlKeywords.add("sp_apply_job_to_targets", Token.KEYWORD3); tsqlKeywords.add("sp_approlepassword", Token.KEYWORD3); tsqlKeywords.add("sp_article_validation", Token.KEYWORD3); tsqlKeywords.add("sp_articlecolumn", Token.KEYWORD3); tsqlKeywords.add("sp_articlefilter", Token.KEYWORD3); tsqlKeywords.add("sp_articlesynctranprocs", Token.KEYWORD3); tsqlKeywords.add("sp_articleview", Token.KEYWORD3); tsqlKeywords.add("sp_attach_db", Token.KEYWORD3); tsqlKeywords.add("sp_attach_single_file_db", Token.KEYWORD3); tsqlKeywords.add("sp_autostats", Token.KEYWORD3); tsqlKeywords.add("sp_bindefault", Token.KEYWORD3); tsqlKeywords.add("sp_bindrule", Token.KEYWORD3); tsqlKeywords.add("sp_bindsession", Token.KEYWORD3); tsqlKeywords.add("sp_browsereplcmds", Token.KEYWORD3); tsqlKeywords.add("sp_catalogs", Token.KEYWORD3); tsqlKeywords.add("sp_certify_removable", Token.KEYWORD3); tsqlKeywords.add("sp_change_agent_parameter", Token.KEYWORD3); tsqlKeywords.add("sp_change_agent_profile", Token.KEYWORD3); tsqlKeywords.add("sp_change_subscription_properties", Token.KEYWORD3); tsqlKeywords.add("sp_change_users_login", Token.KEYWORD3); tsqlKeywords.add("sp_changearticle", Token.KEYWORD3); tsqlKeywords.add("sp_changedbowner", Token.KEYWORD3); tsqlKeywords.add("sp_changedistpublisher", Token.KEYWORD3); tsqlKeywords.add("sp_changedistributiondb", Token.KEYWORD3); tsqlKeywords.add("sp_changedistributor_password", Token.KEYWORD3); tsqlKeywords.add("sp_changedistributor_property", Token.KEYWORD3); tsqlKeywords.add("sp_changegroup", Token.KEYWORD3); tsqlKeywords.add("sp_changemergearticle", Token.KEYWORD3); tsqlKeywords.add("sp_changemergefilter", Token.KEYWORD3); tsqlKeywords.add("sp_changemergepublication", Token.KEYWORD3); tsqlKeywords.add("sp_changemergepullsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_changemergesubscription", Token.KEYWORD3); tsqlKeywords.add("sp_changeobjectowner", Token.KEYWORD3); tsqlKeywords.add("sp_changepublication", Token.KEYWORD3); tsqlKeywords.add("sp_changesubscriber", Token.KEYWORD3); tsqlKeywords.add("sp_changesubscriber_schedule", Token.KEYWORD3); tsqlKeywords.add("sp_changesubstatus", Token.KEYWORD3); tsqlKeywords.add("sp_check_for_sync_trigger", Token.KEYWORD3); tsqlKeywords.add("sp_column_privileges", Token.KEYWORD3); tsqlKeywords.add("sp_column_privileges_ex", Token.KEYWORD3); tsqlKeywords.add("sp_columns", Token.KEYWORD3); tsqlKeywords.add("sp_columns_ex", Token.KEYWORD3); tsqlKeywords.add("sp_configure", Token.KEYWORD3); tsqlKeywords.add("sp_create_removable", Token.KEYWORD3); tsqlKeywords.add("sp_createorphan", Token.KEYWORD3); tsqlKeywords.add("sp_createstats", Token.KEYWORD3); tsqlKeywords.add("sp_cursor", Token.KEYWORD3); tsqlKeywords.add("sp_cursor_list", Token.KEYWORD3); tsqlKeywords.add("sp_cursorclose", Token.KEYWORD3); tsqlKeywords.add("sp_cursorexecute", Token.KEYWORD3); tsqlKeywords.add("sp_cursorfetch", Token.KEYWORD3); tsqlKeywords.add("sp_cursoropen", Token.KEYWORD3); tsqlKeywords.add("sp_cursoroption", Token.KEYWORD3); tsqlKeywords.add("sp_cursorprepare", Token.KEYWORD3); tsqlKeywords.add("sp_cursorunprepare", Token.KEYWORD3); tsqlKeywords.add("sp_cycle_errorlog", Token.KEYWORD3); tsqlKeywords.add("sp_databases", Token.KEYWORD3); tsqlKeywords.add("sp_datatype_info", Token.KEYWORD3); tsqlKeywords.add("sp_dbcmptlevel", Token.KEYWORD3); tsqlKeywords.add("sp_dbfixedrolepermission", Token.KEYWORD3); tsqlKeywords.add("sp_dboption", Token.KEYWORD3); tsqlKeywords.add("sp_defaultdb", Token.KEYWORD3); tsqlKeywords.add("sp_defaultlanguage", Token.KEYWORD3); tsqlKeywords.add("sp_delete_alert", Token.KEYWORD3); tsqlKeywords.add("sp_delete_backuphistory", Token.KEYWORD3); tsqlKeywords.add("sp_delete_category", Token.KEYWORD3); tsqlKeywords.add("sp_delete_job", Token.KEYWORD3); tsqlKeywords.add("sp_delete_jobschedule", Token.KEYWORD3); tsqlKeywords.add("sp_delete_jobserver", Token.KEYWORD3); tsqlKeywords.add("sp_delete_jobstep", Token.KEYWORD3); tsqlKeywords.add("sp_delete_notification", Token.KEYWORD3); tsqlKeywords.add("sp_delete_operator", Token.KEYWORD3); tsqlKeywords.add("sp_delete_targetserver", Token.KEYWORD3); tsqlKeywords.add("sp_delete_targetservergroup", Token.KEYWORD3); tsqlKeywords.add("sp_delete_targetsvrgrp_member", Token.KEYWORD3); tsqlKeywords.add("sp_deletemergeconflictrow", Token.KEYWORD3); tsqlKeywords.add("sp_denylogin", Token.KEYWORD3); tsqlKeywords.add("sp_depends", Token.KEYWORD3); tsqlKeywords.add("sp_describe_cursor", Token.KEYWORD3); tsqlKeywords.add("sp_describe_cursor_columns", Token.KEYWORD3); tsqlKeywords.add("sp_describe_cursor_tables", Token.KEYWORD3); tsqlKeywords.add("sp_detach_db", Token.KEYWORD3); tsqlKeywords.add("sp_drop_agent_parameter", Token.KEYWORD3); tsqlKeywords.add("sp_drop_agent_profile", Token.KEYWORD3); tsqlKeywords.add("sp_dropalias", Token.KEYWORD3); tsqlKeywords.add("sp_dropapprole", Token.KEYWORD3); tsqlKeywords.add("sp_droparticle", Token.KEYWORD3); tsqlKeywords.add("sp_dropdevice", Token.KEYWORD3); tsqlKeywords.add("sp_dropdistpublisher", Token.KEYWORD3); tsqlKeywords.add("sp_dropdistributiondb", Token.KEYWORD3); tsqlKeywords.add("sp_dropdistributor", Token.KEYWORD3); tsqlKeywords.add("sp_dropextendedproc", Token.KEYWORD3); tsqlKeywords.add("sp_dropgroup", Token.KEYWORD3); tsqlKeywords.add("sp_droplinkedsrvlogin", Token.KEYWORD3); tsqlKeywords.add("sp_droplinkedsrvlogin", Token.KEYWORD3); tsqlKeywords.add("sp_droplogin", Token.KEYWORD3); tsqlKeywords.add("sp_dropmergearticle", Token.KEYWORD3); tsqlKeywords.add("sp_dropmergefilter", Token.KEYWORD3); tsqlKeywords.add("sp_dropmergepublication", Token.KEYWORD3); tsqlKeywords.add("sp_dropmergepullsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_dropmergesubscription", Token.KEYWORD3); tsqlKeywords.add("sp_dropmessage", Token.KEYWORD3); tsqlKeywords.add("sp_droporphans", Token.KEYWORD3); tsqlKeywords.add("sp_droppublication", Token.KEYWORD3); tsqlKeywords.add("sp_droppullsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_dropremotelogin", Token.KEYWORD3); tsqlKeywords.add("sp_droprole", Token.KEYWORD3); tsqlKeywords.add("sp_droprolemember", Token.KEYWORD3); tsqlKeywords.add("sp_dropserver", Token.KEYWORD3); tsqlKeywords.add("sp_dropsrvrolemember", Token.KEYWORD3); tsqlKeywords.add("sp_dropsubscriber", Token.KEYWORD3); tsqlKeywords.add("sp_dropsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_droptask", Token.KEYWORD3); tsqlKeywords.add("sp_droptype", Token.KEYWORD3); tsqlKeywords.add("sp_dropuser", Token.KEYWORD3); tsqlKeywords.add("sp_dropwebtask", Token.KEYWORD3); tsqlKeywords.add("sp_dsninfo", Token.KEYWORD3); tsqlKeywords.add("sp_dumpparamcmd", Token.KEYWORD3); tsqlKeywords.add("sp_enumcodepages", Token.KEYWORD3); tsqlKeywords.add("sp_enumcustomresolvers", Token.KEYWORD3); tsqlKeywords.add("sp_enumdsn", Token.KEYWORD3); tsqlKeywords.add("sp_enumfullsubscribers", Token.KEYWORD3); tsqlKeywords.add("sp_execute", Token.KEYWORD3); tsqlKeywords.add("sp_executesql", Token.KEYWORD3); tsqlKeywords.add("sp_expired_subscription_cleanup", Token.KEYWORD3); tsqlKeywords.add("sp_fkeys", Token.KEYWORD3); tsqlKeywords.add("sp_foreignkeys", Token.KEYWORD3); tsqlKeywords.add("sp_fulltext_catalog", Token.KEYWORD3); tsqlKeywords.add("sp_fulltext_column", Token.KEYWORD3); tsqlKeywords.add("sp_fulltext_database", Token.KEYWORD3); tsqlKeywords.add("sp_fulltext_service", Token.KEYWORD3); tsqlKeywords.add("sp_fulltext_table", Token.KEYWORD3); tsqlKeywords.add("sp_generatefilters", Token.KEYWORD3); tsqlKeywords.add("sp_get_distributor", Token.KEYWORD3); tsqlKeywords.add("sp_getbindtoken", Token.KEYWORD3); tsqlKeywords.add("sp_getmergedeletetype", Token.KEYWORD3); tsqlKeywords.add("sp_grant_publication_access", Token.KEYWORD3); tsqlKeywords.add("sp_grantdbaccess", Token.KEYWORD3); tsqlKeywords.add("sp_grantlogin", Token.KEYWORD3); tsqlKeywords.add("sp_help", Token.KEYWORD3); tsqlKeywords.add("sp_help_agent_default", Token.KEYWORD3); tsqlKeywords.add("sp_help_agent_parameter", Token.KEYWORD3); tsqlKeywords.add("sp_help_agent_profile", Token.KEYWORD3); tsqlKeywords.add("sp_help_alert", Token.KEYWORD3); tsqlKeywords.add("sp_help_category", Token.KEYWORD3); tsqlKeywords.add("sp_help_downloadlist", Token.KEYWORD3); tsqlKeywords.add("sp_help_fulltext_catalogs", Token.KEYWORD3); tsqlKeywords.add("sp_help_fulltext_catalogs_cursor", Token.KEYWORD3); tsqlKeywords.add("sp_help_fulltext_columns", Token.KEYWORD3); tsqlKeywords.add("sp_help_fulltext_columns_cursor", Token.KEYWORD3); tsqlKeywords.add("sp_help_fulltext_tables", Token.KEYWORD3); tsqlKeywords.add("sp_help_fulltext_tables_cursor", Token.KEYWORD3); tsqlKeywords.add("sp_help_job", Token.KEYWORD3); tsqlKeywords.add("sp_help_jobhistory", Token.KEYWORD3); tsqlKeywords.add("sp_help_jobschedule", Token.KEYWORD3); tsqlKeywords.add("sp_help_jobserver", Token.KEYWORD3); tsqlKeywords.add("sp_help_jobstep", Token.KEYWORD3); tsqlKeywords.add("sp_help_notification", Token.KEYWORD3); tsqlKeywords.add("sp_help_operator", Token.KEYWORD3); tsqlKeywords.add("sp_help_publication_access", Token.KEYWORD3); tsqlKeywords.add("sp_help_targetserver", Token.KEYWORD3); tsqlKeywords.add("sp_help_targetservergroup", Token.KEYWORD3); tsqlKeywords.add("sp_helparticle", Token.KEYWORD3); tsqlKeywords.add("sp_helparticlecolumns", Token.KEYWORD3); tsqlKeywords.add("sp_helpconstraint", Token.KEYWORD3); tsqlKeywords.add("sp_helpdb", Token.KEYWORD3); tsqlKeywords.add("sp_helpdbfixedrole", Token.KEYWORD3); tsqlKeywords.add("sp_helpdevice", Token.KEYWORD3); tsqlKeywords.add("sp_helpdistpublisher", Token.KEYWORD3); tsqlKeywords.add("sp_helpdistributiondb", Token.KEYWORD3); tsqlKeywords.add("sp_helpdistributor", Token.KEYWORD3); tsqlKeywords.add("sp_helpextendedproc", Token.KEYWORD3); tsqlKeywords.add("sp_helpfile", Token.KEYWORD3); tsqlKeywords.add("sp_helpfilegroup", Token.KEYWORD3); tsqlKeywords.add("sp_helpgroup", Token.KEYWORD3); tsqlKeywords.add("sp_helphistory", Token.KEYWORD3); tsqlKeywords.add("sp_helpindex", Token.KEYWORD3); tsqlKeywords.add("sp_helplanguage", Token.KEYWORD3); tsqlKeywords.add("sp_helplinkedsrvlogin", Token.KEYWORD3); tsqlKeywords.add("sp_helplogins", Token.KEYWORD3); tsqlKeywords.add("sp_helpmergearticle", Token.KEYWORD3); tsqlKeywords.add("sp_helpmergearticleconflicts", Token.KEYWORD3); tsqlKeywords.add("sp_helpmergeconflictrows", Token.KEYWORD3); tsqlKeywords.add("sp_helpmergedeleteconflictrows", Token.KEYWORD3); tsqlKeywords.add("sp_helpmergefilter", Token.KEYWORD3); tsqlKeywords.add("sp_helpmergepublication", Token.KEYWORD3); tsqlKeywords.add("sp_helpmergepullsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_helpmergesubscription", Token.KEYWORD3); tsqlKeywords.add("sp_helpntgroup", Token.KEYWORD3); tsqlKeywords.add("sp_helppublication", Token.KEYWORD3); tsqlKeywords.add("sp_helppullsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_helpremotelogin", Token.KEYWORD3); tsqlKeywords.add("sp_helpreplicationdboption", Token.KEYWORD3); tsqlKeywords.add("sp_helprole", Token.KEYWORD3); tsqlKeywords.add("sp_helprolemember", Token.KEYWORD3); tsqlKeywords.add("sp_helprotect", Token.KEYWORD3); tsqlKeywords.add("sp_helpserver", Token.KEYWORD3); tsqlKeywords.add("sp_helpsort", Token.KEYWORD3); tsqlKeywords.add("sp_helpsrvrole", Token.KEYWORD3); tsqlKeywords.add("sp_helpsrvrolemember", Token.KEYWORD3); tsqlKeywords.add("sp_helpsubscriberinfo", Token.KEYWORD3); tsqlKeywords.add("sp_helpsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_helpsubscription_properties", Token.KEYWORD3); tsqlKeywords.add("sp_helptask", Token.KEYWORD3); tsqlKeywords.add("sp_helptext", Token.KEYWORD3); tsqlKeywords.add("sp_helptrigger", Token.KEYWORD3); tsqlKeywords.add("sp_helpuser", Token.KEYWORD3); tsqlKeywords.add("sp_indexes", Token.KEYWORD3); tsqlKeywords.add("sp_indexoption", Token.KEYWORD3); tsqlKeywords.add("sp_link_publication", Token.KEYWORD3); tsqlKeywords.add("sp_linkedservers", Token.KEYWORD3); tsqlKeywords.add("sp_lock", Token.KEYWORD3); tsqlKeywords.add("sp_makewebtask", Token.KEYWORD3); tsqlKeywords.add("sp_manage_jobs_by_login", Token.KEYWORD3); tsqlKeywords.add("sp_mergedummyupdate", Token.KEYWORD3); tsqlKeywords.add("sp_mergesubscription_cleanup", Token.KEYWORD3); tsqlKeywords.add("sp_monitor", Token.KEYWORD3); tsqlKeywords.add("sp_msx_defect", Token.KEYWORD3); tsqlKeywords.add("sp_msx_enlist", Token.KEYWORD3); tsqlKeywords.add("sp_OACreate", Token.KEYWORD3); tsqlKeywords.add("sp_OADestroy", Token.KEYWORD3); tsqlKeywords.add("sp_OAGetErrorInfo", Token.KEYWORD3); tsqlKeywords.add("sp_OAGetProperty", Token.KEYWORD3); tsqlKeywords.add("sp_OAMethod", Token.KEYWORD3); tsqlKeywords.add("sp_OASetProperty", Token.KEYWORD3); tsqlKeywords.add("sp_OAStop", Token.KEYWORD3); tsqlKeywords.add("sp_password", Token.KEYWORD3); tsqlKeywords.add("sp_pkeys", Token.KEYWORD3); tsqlKeywords.add("sp_post_msx_operation", Token.KEYWORD3); tsqlKeywords.add("sp_prepare", Token.KEYWORD3); tsqlKeywords.add("sp_primarykeys", Token.KEYWORD3); tsqlKeywords.add("sp_processmail", Token.KEYWORD3); tsqlKeywords.add("sp_procoption", Token.KEYWORD3); tsqlKeywords.add("sp_publication_validation", Token.KEYWORD3); tsqlKeywords.add("sp_purge_jobhistory", Token.KEYWORD3); tsqlKeywords.add("sp_purgehistory", Token.KEYWORD3); tsqlKeywords.add("sp_reassigntask", Token.KEYWORD3); tsqlKeywords.add("sp_recompile", Token.KEYWORD3); tsqlKeywords.add("sp_refreshsubscriptions", Token.KEYWORD3); tsqlKeywords.add("sp_refreshview", Token.KEYWORD3); tsqlKeywords.add("sp_reinitmergepullsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_reinitmergesubscription", Token.KEYWORD3); tsqlKeywords.add("sp_reinitpullsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_reinitsubscription", Token.KEYWORD3); tsqlKeywords.add("sp_remoteoption", Token.KEYWORD3); tsqlKeywords.add("sp_remove_job_from_targets", Token.KEYWORD3); tsqlKeywords.add("sp_removedbreplication", Token.KEYWORD3); tsqlKeywords.add("sp_rename", Token.KEYWORD3); tsqlKeywords.add("sp_renamedb", Token.KEYWORD3); tsqlKeywords.add("sp_replcmds", Token.KEYWORD3); tsqlKeywords.add("sp_replcounters", Token.KEYWORD3); tsqlKeywords.add("sp_repldone", Token.KEYWORD3); tsqlKeywords.add("sp_replflush", Token.KEYWORD3); tsqlKeywords.add("sp_replication_agent_checkup", Token.KEYWORD3); tsqlKeywords.add("sp_replicationdboption", Token.KEYWORD3); tsqlKeywords.add("sp_replsetoriginator", Token.KEYWORD3); tsqlKeywords.add("sp_replshowcmds", Token.KEYWORD3); tsqlKeywords.add("sp_repltrans", Token.KEYWORD3); tsqlKeywords.add("sp_reset_connection", Token.KEYWORD3); tsqlKeywords.add("sp_resync_targetserver", Token.KEYWORD3); tsqlKeywords.add("sp_revoke_publication_access", Token.KEYWORD3); tsqlKeywords.add("sp_revokedbaccess", Token.KEYWORD3); tsqlKeywords.add("sp_revokelogin", Token.KEYWORD3); tsqlKeywords.add("sp_runwebtask", Token.KEYWORD3); tsqlKeywords.add("sp_script_synctran_commands", Token.KEYWORD3); tsqlKeywords.add("sp_scriptdelproc", Token.KEYWORD3); tsqlKeywords.add("sp_scriptinsproc", Token.KEYWORD3); tsqlKeywords.add("sp_scriptmappedupdproc", Token.KEYWORD3); tsqlKeywords.add("sp_scriptupdproc", Token.KEYWORD3); tsqlKeywords.add("sp_sdidebug", Token.KEYWORD3); tsqlKeywords.add("sp_server_info", Token.KEYWORD3); tsqlKeywords.add("sp_serveroption", Token.KEYWORD3); tsqlKeywords.add("sp_serveroption", Token.KEYWORD3); tsqlKeywords.add("sp_setapprole", Token.KEYWORD3); tsqlKeywords.add("sp_setnetname", Token.KEYWORD3); tsqlKeywords.add("sp_spaceused", Token.KEYWORD3); tsqlKeywords.add("sp_special_columns", Token.KEYWORD3); tsqlKeywords.add("sp_sproc_columns", Token.KEYWORD3); tsqlKeywords.add("sp_srvrolepermission", Token.KEYWORD3); tsqlKeywords.add("sp_start_job", Token.KEYWORD3); tsqlKeywords.add("sp_statistics", Token.KEYWORD3); tsqlKeywords.add("sp_stop_job", Token.KEYWORD3); tsqlKeywords.add("sp_stored_procedures", Token.KEYWORD3); tsqlKeywords.add("sp_subscription_cleanup", Token.KEYWORD3); tsqlKeywords.add("sp_table_privileges", Token.KEYWORD3); tsqlKeywords.add("sp_table_privileges_ex", Token.KEYWORD3); tsqlKeywords.add("sp_table_validation", Token.KEYWORD3); tsqlKeywords.add("sp_tableoption", Token.KEYWORD3); tsqlKeywords.add("sp_tables", Token.KEYWORD3); tsqlKeywords.add("sp_tables_ex", Token.KEYWORD3); tsqlKeywords.add("sp_unbindefault", Token.KEYWORD3); tsqlKeywords.add("sp_unbindrule", Token.KEYWORD3); tsqlKeywords.add("sp_unprepare", Token.KEYWORD3); tsqlKeywords.add("sp_update_agent_profile", Token.KEYWORD3); tsqlKeywords.add("sp_update_alert", Token.KEYWORD3); tsqlKeywords.add("sp_update_category", Token.KEYWORD3); tsqlKeywords.add("sp_update_job", Token.KEYWORD3); tsqlKeywords.add("sp_update_jobschedule", Token.KEYWORD3); tsqlKeywords.add("sp_update_jobstep", Token.KEYWORD3); tsqlKeywords.add("sp_update_notification", Token.KEYWORD3); tsqlKeywords.add("sp_update_operator", Token.KEYWORD3); tsqlKeywords.add("sp_update_targetservergroup", Token.KEYWORD3); tsqlKeywords.add("sp_updatestats", Token.KEYWORD3); tsqlKeywords.add("sp_updatetask", Token.KEYWORD3); tsqlKeywords.add("sp_validatelogins", Token.KEYWORD3); tsqlKeywords.add("sp_validname", Token.KEYWORD3); tsqlKeywords.add("sp_who", Token.KEYWORD3); tsqlKeywords.add("xp_cmdshell", Token.KEYWORD3); tsqlKeywords.add("xp_deletemail", Token.KEYWORD3); tsqlKeywords.add("xp_enumgroups", Token.KEYWORD3); tsqlKeywords.add("xp_findnextmsg", Token.KEYWORD3); tsqlKeywords.add("xp_findnextmsg", Token.KEYWORD3); tsqlKeywords.add("xp_grantlogin", Token.KEYWORD3); tsqlKeywords.add("xp_logevent", Token.KEYWORD3); tsqlKeywords.add("xp_loginconfig", Token.KEYWORD3); tsqlKeywords.add("xp_logininfo", Token.KEYWORD3); tsqlKeywords.add("xp_msver", Token.KEYWORD3); tsqlKeywords.add("xp_readmail", Token.KEYWORD3); tsqlKeywords.add("xp_revokelogin", Token.KEYWORD3); tsqlKeywords.add("xp_sendmail", Token.KEYWORD3); tsqlKeywords.add("xp_sprintf", Token.KEYWORD3); tsqlKeywords.add("xp_sqlinventory", Token.KEYWORD3); tsqlKeywords.add("xp_sqlmaint", Token.KEYWORD3); tsqlKeywords.add("xp_sqltrace", Token.KEYWORD3); tsqlKeywords.add("xp_sscanf", Token.KEYWORD3); tsqlKeywords.add("xp_startmail", Token.KEYWORD3); tsqlKeywords.add("xp_stopmail", Token.KEYWORD3); tsqlKeywords.add("xp_trace_addnewqueue", Token.KEYWORD3); tsqlKeywords.add("xp_trace_deletequeuedefinition", Token.KEYWORD3); tsqlKeywords.add("xp_trace_destroyqueue", Token.KEYWORD3); tsqlKeywords.add("xp_trace_enumqueuedefname", Token.KEYWORD3); tsqlKeywords.add("xp_trace_enumqueuehandles", Token.KEYWORD3); tsqlKeywords.add("xp_trace_eventclassrequired", Token.KEYWORD3); tsqlKeywords.add("xp_trace_flushqueryhistory", Token.KEYWORD3); tsqlKeywords.add("xp_trace_generate_event", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getappfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getconnectionidfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getcpufilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getdbidfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getdurationfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_geteventfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_geteventnames", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getevents", Token.KEYWORD3); tsqlKeywords.add("xp_trace_gethostfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_gethpidfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getindidfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getntdmfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getntnmfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getobjidfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getqueueautostart", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getqueuedestination", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getqueueproperties", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getreadfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getserverfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getseverityfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getspidfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getsysobjectsfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_gettextfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getuserfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_getwritefilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_loadqueuedefinition", Token.KEYWORD3); tsqlKeywords.add("xp_trace_pausequeue", Token.KEYWORD3); tsqlKeywords.add("xp_trace_restartqueue", Token.KEYWORD3); tsqlKeywords.add("xp_trace_savequeuedefinition", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setappfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setconnectionidfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setcpufilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setdbidfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setdurationfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_seteventclassrequired", Token.KEYWORD3); tsqlKeywords.add("xp_trace_seteventfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_sethostfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_sethpidfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setindidfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setntdmfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setntnmfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setobjidfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setqueryhistory", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setqueueautostart", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setqueuecreateinfo", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setqueuedestination", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setreadfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setserverfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setseverityfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setspidfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setsysobjectsfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_settextfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setuserfilter", Token.KEYWORD3); tsqlKeywords.add("xp_trace_setwritefilter", Token.KEYWORD3); } private static void addSystemTables() { tsqlKeywords.add("backupfile", Token.KEYWORD3); tsqlKeywords.add("backupmediafamily", Token.KEYWORD3); tsqlKeywords.add("backupmediaset", Token.KEYWORD3); tsqlKeywords.add("backupset", Token.KEYWORD3); tsqlKeywords.add("MSagent_parameters", Token.KEYWORD3); tsqlKeywords.add("MSagent_profiles", Token.KEYWORD3); tsqlKeywords.add("MSarticles", Token.KEYWORD3); tsqlKeywords.add("MSdistpublishers", Token.KEYWORD3); tsqlKeywords.add("MSdistribution_agents", Token.KEYWORD3); tsqlKeywords.add("MSdistribution_history", Token.KEYWORD3); tsqlKeywords.add("MSdistributiondbs", Token.KEYWORD3); tsqlKeywords.add("MSdistributor", Token.KEYWORD3); tsqlKeywords.add("MSlogreader_agents", Token.KEYWORD3); tsqlKeywords.add("MSlogreader_history", Token.KEYWORD3); tsqlKeywords.add("MSmerge_agents", Token.KEYWORD3); tsqlKeywords.add("MSmerge_contents", Token.KEYWORD3); tsqlKeywords.add("MSmerge_delete_conflicts", Token.KEYWORD3); tsqlKeywords.add("MSmerge_genhistory", Token.KEYWORD3); tsqlKeywords.add("MSmerge_history", Token.KEYWORD3); tsqlKeywords.add("MSmerge_replinfo", Token.KEYWORD3); tsqlKeywords.add("MSmerge_subscriptions", Token.KEYWORD3); tsqlKeywords.add("MSmerge_tombstone", Token.KEYWORD3); tsqlKeywords.add("MSpublication_access", Token.KEYWORD3); tsqlKeywords.add("Mspublications", Token.KEYWORD3); tsqlKeywords.add("Mspublisher_databases", Token.KEYWORD3); tsqlKeywords.add("MSrepl_commands", Token.KEYWORD3); tsqlKeywords.add("MSrepl_errors", Token.KEYWORD3); tsqlKeywords.add("Msrepl_originators", Token.KEYWORD3); tsqlKeywords.add("MSrepl_transactions", Token.KEYWORD3); tsqlKeywords.add("MSrepl_version", Token.KEYWORD3); tsqlKeywords.add("MSreplication_objects", Token.KEYWORD3); tsqlKeywords.add("MSreplication_subscriptions", Token.KEYWORD3); tsqlKeywords.add("MSsnapshot_agents", Token.KEYWORD3); tsqlKeywords.add("MSsnapshot_history", Token.KEYWORD3); tsqlKeywords.add("MSsubscriber_info", Token.KEYWORD3); tsqlKeywords.add("MSsubscriber_schedule", Token.KEYWORD3); tsqlKeywords.add("MSsubscription_properties", Token.KEYWORD3); tsqlKeywords.add("MSsubscriptions", Token.KEYWORD3); tsqlKeywords.add("restorefile", Token.KEYWORD3); tsqlKeywords.add("restorefilegroup", Token.KEYWORD3); tsqlKeywords.add("restorehistory", Token.KEYWORD3); tsqlKeywords.add("sysalerts", Token.KEYWORD3); tsqlKeywords.add("sysallocations", Token.KEYWORD3); tsqlKeywords.add("sysaltfiles", Token.KEYWORD3); tsqlKeywords.add("sysarticles", Token.KEYWORD3); tsqlKeywords.add("sysarticleupdates", Token.KEYWORD3); tsqlKeywords.add("syscacheobjects", Token.KEYWORD3); tsqlKeywords.add("syscategories", Token.KEYWORD3); tsqlKeywords.add("syscharsets", Token.KEYWORD3); tsqlKeywords.add("syscolumns", Token.KEYWORD3); tsqlKeywords.add("syscomments", Token.KEYWORD3); tsqlKeywords.add("sysconfigures", Token.KEYWORD3); tsqlKeywords.add("sysconstraints", Token.KEYWORD3); tsqlKeywords.add("syscurconfigs", Token.KEYWORD3); tsqlKeywords.add("sysdatabases", Token.KEYWORD3); tsqlKeywords.add("sysdatabases", Token.KEYWORD3); tsqlKeywords.add("sysdepends", Token.KEYWORD3); tsqlKeywords.add("sysdevices", Token.KEYWORD3); tsqlKeywords.add("sysdownloadlist", Token.KEYWORD3); tsqlKeywords.add("sysfilegroups", Token.KEYWORD3); tsqlKeywords.add("sysfiles", Token.KEYWORD3); tsqlKeywords.add("sysforeignkeys", Token.KEYWORD3); tsqlKeywords.add("sysfulltextcatalogs", Token.KEYWORD3); tsqlKeywords.add("sysindexes", Token.KEYWORD3); tsqlKeywords.add("sysindexkeys", Token.KEYWORD3); tsqlKeywords.add("sysjobhistory", Token.KEYWORD3); tsqlKeywords.add("sysjobs", Token.KEYWORD3); tsqlKeywords.add("sysjobschedules", Token.KEYWORD3); tsqlKeywords.add("sysjobservers", Token.KEYWORD3); tsqlKeywords.add("sysjobsteps", Token.KEYWORD3); tsqlKeywords.add("syslanguages", Token.KEYWORD3); tsqlKeywords.add("syslockinfo", Token.KEYWORD3); tsqlKeywords.add("syslogins", Token.KEYWORD3); tsqlKeywords.add("sysmembers", Token.KEYWORD3); tsqlKeywords.add("sysmergearticles", Token.KEYWORD3); tsqlKeywords.add("sysmergepublications", Token.KEYWORD3); tsqlKeywords.add("sysmergeschemachange", Token.KEYWORD3); tsqlKeywords.add("sysmergesubscriptions", Token.KEYWORD3); tsqlKeywords.add("sysmergesubsetfilters", Token.KEYWORD3); tsqlKeywords.add("sysmessages", Token.KEYWORD3); tsqlKeywords.add("sysnotifications", Token.KEYWORD3); tsqlKeywords.add("sysobjects", Token.KEYWORD3); tsqlKeywords.add("sysobjects", Token.KEYWORD3); tsqlKeywords.add("sysoledbusers", Token.KEYWORD3); tsqlKeywords.add("sysoperators", Token.KEYWORD3); tsqlKeywords.add("sysperfinfo", Token.KEYWORD3); tsqlKeywords.add("syspermissions", Token.KEYWORD3); tsqlKeywords.add("sysprocesses", Token.KEYWORD3); tsqlKeywords.add("sysprotects", Token.KEYWORD3); tsqlKeywords.add("syspublications", Token.KEYWORD3); tsqlKeywords.add("sysreferences", Token.KEYWORD3); tsqlKeywords.add("sysremotelogins", Token.KEYWORD3); tsqlKeywords.add("sysreplicationalerts", Token.KEYWORD3); tsqlKeywords.add("sysservers", Token.KEYWORD3); tsqlKeywords.add("sysservers", Token.KEYWORD3); tsqlKeywords.add("syssubscriptions", Token.KEYWORD3); tsqlKeywords.add("systargetservergroupmembers", Token.KEYWORD3); tsqlKeywords.add("systargetservergroups", Token.KEYWORD3); tsqlKeywords.add("systargetservers", Token.KEYWORD3); tsqlKeywords.add("systaskids", Token.KEYWORD3); tsqlKeywords.add("systypes", Token.KEYWORD3); tsqlKeywords.add("sysusers", Token.KEYWORD3); } private static KeywordMap tsqlKeywords; }