Difference between revisions of "Reserved Words"
From AgileApps Support Wiki
imported>Aeric |
Wikieditor (talk | contribs) Tag: Manual revert |
||
(5 intermediate revisions by 2 users not shown) | |||
Line 3: | Line 3: | ||
:{| | :{| | ||
| valign="top" | <pre>A | | valign="top" | <pre>A | ||
ABSTRACT | ABSTRACT | ||
ACCESSIBLE | ACCESSIBLE | ||
Line 12: | Line 11: | ||
ALTER | ALTER | ||
ANALYZE | ANALYZE | ||
AND | AND | ||
APPOINTMENTS | APPOINTMENTS | ||
Line 43: | Line 41: | ||
CHARACTER | CHARACTER | ||
CHECK | CHECK | ||
CLASS | CLASS | ||
COFF | COFF | ||
Line 72: | Line 69: | ||
CRITERIA | CRITERIA | ||
CROSS | CROSS | ||
CUBE | |||
CUME_DIST | |||
CURRENT_DATE | CURRENT_DATE | ||
CURRENT_TIME | CURRENT_TIME | ||
Line 95: | Line 94: | ||
DECIMAL | DECIMAL | ||
DECLARE | DECLARE | ||
DEFAULT | DEFAULT | ||
DELAYED | DELAYED | ||
DELETE | DELETE | ||
DENSE_RANK | |||
DESC | DESC | ||
DESCRIBE | DESCRIBE | ||
Line 108: | Line 107: | ||
DOCUMENTS | DOCUMENTS | ||
DONE | DONE | ||
DOUBLE | DOUBLE | ||
DROP | DROP | ||
DUAL | DUAL | ||
EACH | EACH | ||
ELSE | ELSE | ||
ELSEIF | ELSEIF | ||
EMAIL_ACTIVITIES | EMAIL_ACTIVITIES | ||
EMPTY | |||
ENCLOSED | ENCLOSED | ||
ENDSWITH | ENDSWITH | ||
Line 122: | Line 120: | ||
ERRORS | ERRORS | ||
ESCAPED | ESCAPED | ||
EXCEPT | |||
EXISTS | EXISTS | ||
EXIT | EXIT | ||
Line 134: | Line 133: | ||
FIND | FIND | ||
FIRST_NAME | FIRST_NAME | ||
FIRST_VALUE | |||
FLOAT | FLOAT | ||
FLOAT4 | FLOAT4 | ||
Line 144: | Line 144: | ||
FULLTEXT | FULLTEXT | ||
FUNCTION | FUNCTION | ||
GENERAL | |||
GENERATED | |||
GEOMETRY | GEOMETRY | ||
GET | |||
GOTO | GOTO | ||
</pre> | </pre> | ||
| valign="top" | <pre>GROUP | | valign="top" | <pre>GROUP | ||
GRANT | |||
GROUPING | |||
GROUPS | |||
HASH | HASH | ||
HAVING | HAVING | ||
Line 160: | Line 164: | ||
HOUR_SECOND | HOUR_SECOND | ||
ID | ID | ||
IF | IF | ||
IGNORE | IGNORE | ||
IGNORE_SERVER_IDS | |||
IMPLEMENTS | IMPLEMENTS | ||
IMPORT | IMPORT | ||
Line 182: | Line 186: | ||
INTEGER | INTEGER | ||
INTERFACE | INTERFACE | ||
INTERSECT | |||
INTERVAL | INTERVAL | ||
INTO | INTO | ||
IO_AFTER_GTIDS | |||
IO_BEFORE_GTIDS | |||
IS | IS | ||
ISCHANGED | ISCHANGED | ||
Line 190: | Line 197: | ||
ITERATE | ITERATE | ||
JOIN | JOIN | ||
JSON_TABLE | |||
KEY | KEY | ||
KEYS | KEYS | ||
KILL | KILL | ||
LABEL | LABEL | ||
LAG | |||
LAST_MODIFIED_TIMESTAMP | LAST_MODIFIED_TIMESTAMP | ||
LAST_NAME | LAST_NAME | ||
LAST_VALUE | |||
LATERAL | |||
LEAD | |||
LEADING | LEADING | ||
LEAVE | LEAVE | ||
Line 217: | Line 229: | ||
LOW_PRIORITY | LOW_PRIORITY | ||
LOWER | LOWER | ||
MASTER_BIND | |||
MASTER_HEAERBEAT_PERIOD | |||
MASTER_SERVER_ID | MASTER_SERVER_ID | ||
MASTER_SSL_VERIFY_SERVER_CERT | MASTER_SSL_VERIFY_SERVER_CERT | ||
MATCH | MATCH | ||
MAX | MAX | ||
MAXVALUE | |||
MAXVALUE | |||
MEDIUMBLOB | MEDIUMBLOB | ||
MEDIUMINT | MEDIUMINT | ||
Line 229: | Line 245: | ||
MINUTE_MICROSECOND | MINUTE_MICROSECOND | ||
MINUTE_SECOND | MINUTE_SECOND | ||
MOD | MOD | ||
MODIFIED_ID | MODIFIED_ID | ||
Line 241: | Line 256: | ||
NEW | NEW | ||
NO_WRITE_TO_BINLOG | NO_WRITE_TO_BINLOG | ||
NOT | NOT | ||
NOW | NOW | ||
NTH_VALUE | |||
NTILE | |||
NULL | NULL | ||
NUMERIC | NUMERIC | ||
OBJECT_ID | OBJECT_ID | ||
OF | |||
ON | ON | ||
OPPORTUNITIES | OPPORTUNITIES | ||
OPTIMIZE | OPTIMIZE | ||
OPTIMIZER_COSTS | |||
OPTION | OPTION | ||
OPTIONALLY | OPTIONALLY | ||
OR | OR | ||
ORDER | ORDER | ||
Line 258: | Line 275: | ||
OUTER | OUTER | ||
OUTFILE | OUTFILE | ||
OVER | |||
OWNER | OWNER | ||
OWNER_ID | OWNER_ID | ||
Line 263: | Line 281: | ||
P_KEYWORD | P_KEYWORD | ||
PACKAGE | PACKAGE | ||
PARTITION | |||
PERCENT_RANK | |||
PLANS | PLANS | ||
POW | POW | ||
Line 278: | Line 298: | ||
PURGE | PURGE | ||
PURPOSE_ACCOUNT | PURPOSE_ACCOUNT | ||
</pre> | |||
| valign="top" | <pre>GROUP | |||
PURPOSE_CASE | PURPOSE_CASE | ||
PURPOSE_CONTACT | PURPOSE_CONTACT | ||
Line 287: | Line 309: | ||
PURPOSE_PROJECT | PURPOSE_PROJECT | ||
RANGE | RANGE | ||
RANK | |||
READ | READ | ||
READ_ONLY | READ_ONLY | ||
Line 293: | Line 316: | ||
REAL | REAL | ||
RECORD | RECORD | ||
RECURSIVE | |||
REFERENCES | REFERENCES | ||
RELEASE | RELEASE | ||
RENAME | RENAME | ||
REPEAT | REPEAT | ||
REPLACE | REPLACE | ||
REQUIRE | REQUIRE | ||
RESIGNAL | |||
RESIGNAL | |||
RESTRICT | RESTRICT | ||
RETURN | RETURN | ||
Line 309: | Line 332: | ||
RLIKE | RLIKE | ||
ROUND | ROUND | ||
ROW | |||
ROW_NUMBER | |||
ROWS | |||
RTREE | RTREE | ||
S | S | ||
Line 332: | Line 358: | ||
SIGN_HASH_PRODUCT | SIGN_HASH_PRODUCT | ||
SIGN_HASH_PROJECT | SIGN_HASH_PROJECT | ||
SIGNAL | |||
SIGNAL | |||
SIGNED_BY_ACCOUNT | SIGNED_BY_ACCOUNT | ||
SIGNED_BY_CASE | SIGNED_BY_CASE | ||
Line 350: | Line 378: | ||
SIGNED_BY_PRODUCT | SIGNED_BY_PRODUCT | ||
SIGNED_BY_PROJECT | SIGNED_BY_PROJECT | ||
SLOW | |||
SMALLINT | SMALLINT | ||
SOME | SOME | ||
Line 369: | Line 398: | ||
STARTSWITH | STARTSWITH | ||
STATIC | STATIC | ||
STORED | |||
STRAIGHT_JOIN | STRAIGHT_JOIN | ||
STRICTFP | STRICTFP | ||
Line 376: | Line 406: | ||
SWITCH | SWITCH | ||
SYNCHRONIZED | SYNCHRONIZED | ||
SYSTEM | |||
T | T | ||
TABLE | TABLE | ||
Line 416: | Line 447: | ||
USERID | USERID | ||
USERPRIMARYTEAMID | USERPRIMARYTEAMID | ||
</pre> | |||
| valign="top" | <pre>GROUP | |||
USING | USING | ||
UTC_DATE | UTC_DATE | ||
Line 426: | Line 459: | ||
VARCHARACTER | VARCHARACTER | ||
VARYING | VARYING | ||
VIRTUAL | |||
VOID | VOID | ||
VOLATILE | VOLATILE | ||
Line 433: | Line 467: | ||
WHERE | WHERE | ||
WHILE | WHILE | ||
WINDOW | |||
WITH | WITH | ||
WORKFLOW_HISTORY | WORKFLOW_HISTORY |
Latest revision as of 10:05, 10 October 2022
These words are used within the platform internally, and cannot be used for names.
- See also: Reserved Words by Group
A ABSTRACT ACCESSIBLE ACTIVITIES ADD AFFILIATE_ID ALL ALTER ANALYZE AND APPOINTMENTS AS ASC ASENSITIVE ASSERT AUTO_INCREMENT BDB BEFORE BETWEEN BIGINT BINARY BLOB BOOLEAN BOTH BREAK BTREE BY BYTE CALL CAMPAIGNS CASCADE CASE CASES CATCH CEIL CHANGE CHAR CHARACTER CHECK CLASS COFF COLLATE COLUMN COLUMNS COMMENTS CONCAT CONDITION CONNECTION CONST CONSTRAINT contact_email contact_fax contact_first_name contact_last_name contact_mobile_phone contact_phone contact_title CONTACTS CONTAINS CONTINUE CONTRACTS CONVERT CREATE CREATED_ID CREATOR CRITERIA CROSS CUBE CUME_DIST CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CUSTOMER_ID DATABASE DATABASES DATE DATE_CREATED DATE_MODIFIED DATEADD DATECOMP DATESUB DATEVALUE DAY DAY_HOUR DAY_MICROSECOND DAY_MINUTE DAY_SECOND DEC DECIMAL DECLARE DEFAULT DELAYED DELETE DENSE_RANK DESC DESCRIBE DETERMINISTIC DISTINCT DISTINCTROW DIV DO DOCUMENTS DONE DOUBLE DROP DUAL EACH ELSE ELSEIF EMAIL_ACTIVITIES EMPTY ENCLOSED ENDSWITH ENUM ERRORS ESCAPED EXCEPT EXISTS EXIT EXP EXPLAIN EXTENDS FALSE FETCH FIELDS FINAL FINALLY FIND FIRST_NAME FIRST_VALUE FLOAT FLOAT4 FLOAT8 FLOOR FOR FORCE FOREIGN FROM FULLTEXT FUNCTION GENERAL GENERATED GEOMETRY GET GOTO
GROUP GRANT GROUPING GROUPS HASH HAVING HELP HIGH_PRIORITY HISTORY HOUR HOUR_MICROSECOND HOUR_MINUTE HOUR_SECOND ID IF IGNORE IGNORE_SERVER_IDS IMPLEMENTS IMPORT IN INDEX INFILE INNER INNODB INOUT INSENSITIVE INSERT INSTANCEOF INT INT1 INT2 INT3 INT4 INT8 INTEGER INTERFACE INTERSECT INTERVAL INTO IO_AFTER_GTIDS IO_BEFORE_GTIDS IS ISCHANGED ISNEW ISNULL ITERATE JOIN JSON_TABLE KEY KEYS KILL LABEL LAG LAST_MODIFIED_TIMESTAMP LAST_NAME LAST_VALUE LATERAL LEAD LEADING LEAVE LEFT LEN LIFECYCLE LIKE LIMIT LINEAR LINES LN LOAD LOCALTIME LOCALTIMESTAMP LOCK LOG LONG LONGBLOB LONGTEXT LOOP LOW_PRIORITY LOWER MASTER_BIND MASTER_HEAERBEAT_PERIOD MASTER_SERVER_ID MASTER_SSL_VERIFY_SERVER_CERT MATCH MAX MAXVALUE MAXVALUE MEDIUMBLOB MEDIUMINT MEDIUMTEXT MIDDLEINT MIN MINUTE MINUTE_MICROSECOND MINUTE_SECOND MOD MODIFIED_ID MODIFIER MODIFIES MONTH MRG_MYISAM NAME NATIVE NATURAL NEW NO_WRITE_TO_BINLOG NOT NOW NTH_VALUE NTILE NULL NUMERIC OBJECT_ID OF ON OPPORTUNITIES OPTIMIZE OPTIMIZER_COSTS OPTION OPTIONALLY OR ORDER OUT OUTER OUTFILE OVER OWNER OWNER_ID OWNER_TEAM_ID P_KEYWORD PACKAGE PARTITION PERCENT_RANK PLANS POW PRECISION PRICELIST PRIMARY PRIOR_NAME PRIORVALUE PRIVATE PRIVILEGES PROCEDURE PRODUCTS PROTECTED PUBLIC PURGE PURPOSE_ACCOUNT
GROUP PURPOSE_CASE PURPOSE_CONTACT PURPOSE_CONTRACT PURPOSE_LEAD PURPOSE_OPPORTUNITY_V2 PURPOSE_PRICE_BOOK PURPOSE_PRODUCT PURPOSE_PROJECT RANGE RANK READ READ_ONLY READ_WRITE READS REAL RECORD RECURSIVE REFERENCES RELEASE RENAME REPEAT REPLACE REQUIRE RESIGNAL RESIGNAL RESTRICT RETURN RETURNS REVOKE RIGHT RLIKE ROUND ROW ROW_NUMBER ROWS RTREE S SCHEMA SCHEMAS SEARCH_STRING SECOND SECOND_MICROSECOND SELECT SENSITIVE SEPARATOR SET SHORT SHOW SHOW_LAYOUT SIGN_HASH_ACCOUNT SIGN_HASH_CASE SIGN_HASH_CONTACT SIGN_HASH_CONTRACT SIGN_HASH_LEAD SIGN_HASH_OPPORTUNITY_V2 SIGN_HASH_PRICE_BOOK SIGN_HASH_PRODUCT SIGN_HASH_PROJECT SIGNAL SIGNAL SIGNED_BY_ACCOUNT SIGNED_BY_CASE SIGNED_BY_CONTACT SIGNED_BY_CONTRACT SIGNED_BY_DATE_ACCOUNT SIGNED_BY_DATE_CASE SIGNED_BY_DATE_CONTACT SIGNED_BY_DATE_CONTRACT SIGNED_BY_DATE_LEAD SIGNED_BY_DATE_OPPORTUNITY_V2 SIGNED_BY_DATE_PRICE_BOOK SIGNED_BY_DATE_PRODUCT SIGNED_BY_DATE_PROJECT SIGNED_BY_LEAD SIGNED_BY_OPPORTUNITY_V2 SIGNED_BY_PRICE_BOOK SIGNED_BY_PRODUCT SIGNED_BY_PROJECT SLOW SMALLINT SOME SONAME SOURCEPAGE SPATIAL SPECIFIC SPENDING SQL SQL_BIG_RESULT SQL_CALC_FOUND_ROWS SQL_SMALL_RESULT SQLEXCEPTION SQLSTATE SQLWARNING SQRT SSL STARTING STARTSWITH STATIC STORED STRAIGHT_JOIN STRICTFP STRIPED SUBSTRING SUPER SWITCH SYNCHRONIZED SYSTEM T TABLE TABLES TAGLIST TARGETPAGE TERMINATED TEXT THEN THIS THROW THROWS TIME TIMEVALUE TINYBLOB TINYINT TINYTEXT TO TODAY TOP_TAB TRAILING TRANSIENT TRIGGER TRIM TRUE TRY TYPES UNDO UNION UNIQUE UNLOCK UNSIGNED UPDATE UPGRADE UPPER USAGE USE USER USER_RESOURCES USERID USERPRIMARYTEAMID
GROUP USING UTC_DATE UTC_TIME UTC_TIMESTAMP VALUE VALUES VARBINARY VARCHAR VARCHARACTER VARYING VIRTUAL VOID VOLATILE WARNINGS WEEKDAY WHEN WHERE WHILE WINDOW WITH WORKFLOW_HISTORY WRITE XOR YEAR YEAR_MONTH ZEROFILL