Difference between revisions of "Reserved Words"

From AgileApps Support Wiki
Tag: Reverted
Tags: Manual revert Reverted
Line 3: Line 3:
:{|  
:{|  
| valign="top" | <pre>A
| valign="top" | <pre>A
ABS
ABSTRACT
ABSTRACT
ACCESSIBLE
ACCESSIBLE
Line 11: Line 12:
ALTER
ALTER
ANALYZE
ANALYZE
AND
AND
AND
APPOINTMENTS
APPOINTMENTS
Line 41: Line 43:
CHARACTER
CHARACTER
CHECK
CHECK
CLASS
CLASS
CLASS
COFF
COFF
Line 69: Line 72:
CRITERIA
CRITERIA
CROSS
CROSS
CUBE            
CUME_DIST        
CURRENT_DATE
CURRENT_DATE
CURRENT_TIME
CURRENT_TIME
Line 94: Line 95:
DECIMAL
DECIMAL
DECLARE
DECLARE
DEFAULT
DEFAULT
DEFAULT
DELAYED
DELAYED
DELETE
DELETE
DENSE_RANK        
DESC
DESC
DESCRIBE
DESCRIBE
Line 107: Line 108:
DOCUMENTS
DOCUMENTS
DONE
DONE
DOUBLE
DOUBLE
DOUBLE
DROP
DROP
DUAL
DUAL
EACH
EACH
ELSE
ELSE
ELSE
ELSEIF
ELSEIF
EMAIL_ACTIVITIES
EMAIL_ACTIVITIES
EMPTY            
ENCLOSED
ENCLOSED
ENDSWITH
ENDSWITH
Line 120: Line 122:
ERRORS
ERRORS
ESCAPED
ESCAPED
EXCEPT            
EXISTS
EXISTS
EXIT
EXIT
Line 133: Line 134:
FIND
FIND
FIRST_NAME
FIRST_NAME
FIRST_VALUE        
FLOAT
FLOAT
FLOAT4
FLOAT4
Line 145: Line 145:
FUNCTION
FUNCTION
GENERAL
GENERAL
GENERATED        
GEOMETRY
GEOMETRY
GET                
GOTO
GOTO
GOTO
GRANT
</pre>
</pre>
| valign="top" | <pre>GROUP
| valign="top" | <pre>GROUP
GRANT
GROUPING        
GROUPS            
HASH
HASH
HAVING
HAVING
Line 164: Line 161:
HOUR_SECOND
HOUR_SECOND
ID
ID
IF
IF
IF
IGNORE
IGNORE
Line 186: Line 184:
INTEGER
INTEGER
INTERFACE
INTERFACE
INTERSECT        
INTERVAL
INTERVAL
INTO
INTO
IO_AFTER_GTIDS    
IO_BEFORE_GTIDS    
IS
IS
ISCHANGED
ISCHANGED
Line 197: Line 192:
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 229: Line 219:
LOW_PRIORITY
LOW_PRIORITY
LOWER
LOWER
MASTER_BIND        
MASTER_HEAERBEAT_PERIOD
MASTER_HEAERBEAT_PERIOD
MASTER_SERVER_ID
MASTER_SERVER_ID
Line 236: Line 225:
MAX
MAX
MAXVALUE
MAXVALUE
MAXVALUE        
MEDIUMBLOB
MEDIUMBLOB
MEDIUMINT
MEDIUMINT
Line 245: Line 233:
MINUTE_MICROSECOND
MINUTE_MICROSECOND
MINUTE_SECOND
MINUTE_SECOND
MOD
MOD
MOD
MODIFIED_ID
MODIFIED_ID
Line 256: Line 245:
NEW
NEW
NO_WRITE_TO_BINLOG
NO_WRITE_TO_BINLOG
NOT
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
OR
ORDER
ORDER
Line 275: Line 262:
OUTER
OUTER
OUTFILE
OUTFILE
OVER            
OWNER
OWNER
OWNER_ID
OWNER_ID
Line 281: Line 267:
P_KEYWORD
P_KEYWORD
PACKAGE
PACKAGE
PARTITION        
PERCENT_RANK    
PLANS
PLANS
POW
POW
Line 298: Line 282:
PURGE
PURGE
PURPOSE_ACCOUNT
PURPOSE_ACCOUNT
</pre>
| valign="top" | <pre>GROUP
PURPOSE_CASE
PURPOSE_CASE
PURPOSE_CONTACT
PURPOSE_CONTACT
Line 309: Line 291:
PURPOSE_PROJECT
PURPOSE_PROJECT
RANGE                 
RANGE                 
RANK            
READ
READ
READ_ONLY       
READ_ONLY       
Line 316: Line 297:
REAL
REAL
RECORD
RECORD
RECURSIVE        
REFERENCES
REFERENCES
</pre>
| valign="top" | <pre>REGEXP
RELEASE
RELEASE
RENAME
RENAME
REPEAT
REPEAT
REPLACE
REPLACE
REPLACE
REQUIRE
REQUIRE
RESIGNAL
RESIGNAL
RESIGNAL        
RESTRICT
RESTRICT
RETURN
RETURN
Line 332: Line 314:
RLIKE
RLIKE
ROUND
ROUND
ROW                
ROW_NUMBER        
ROWS            
RTREE
RTREE
S
S
Line 359: Line 338:
SIGN_HASH_PROJECT
SIGN_HASH_PROJECT
SIGNAL
SIGNAL
SIGNAL            
SIGNED_BY_ACCOUNT
SIGNED_BY_ACCOUNT
SIGNED_BY_CASE
SIGNED_BY_CASE
Line 398: Line 376:
STARTSWITH
STARTSWITH
STATIC
STATIC
STORED            
STRAIGHT_JOIN
STRAIGHT_JOIN
STRICTFP
STRICTFP
Line 406: Line 383:
SWITCH
SWITCH
SYNCHRONIZED
SYNCHRONIZED
SYSTEM            
T
T
TABLE
TABLE
Line 447: Line 423:
USERID
USERID
USERPRIMARYTEAMID
USERPRIMARYTEAMID
</pre>
| valign="top" | <pre>GROUP
USING
USING
UTC_DATE
UTC_DATE
Line 459: Line 433:
VARCHARACTER
VARCHARACTER
VARYING
VARYING
VIRTUAL            
VOID
VOID
VOLATILE
VOLATILE
Line 467: Line 440:
WHERE
WHERE
WHILE
WHILE
WINDOW 
WITH
WITH
WORKFLOW_HISTORY
WORKFLOW_HISTORY

Revision as of 10:16, 6 September 2022

These words are used within the platform internally, and cannot be used for names.

See also: Reserved Words by Group
A
ABS
ABSTRACT
ACCESSIBLE
ACTIVITIES
ADD
AFFILIATE_ID
ALL
ALTER
ANALYZE
AND
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
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
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
DEFAULT
DELAYED
DELETE
DESC
DESCRIBE
DETERMINISTIC
DISTINCT
DISTINCTROW
DIV
DO
DOCUMENTS
DONE
DOUBLE
DOUBLE
DROP
DUAL
EACH
ELSE
ELSE
ELSEIF
EMAIL_ACTIVITIES
ENCLOSED
ENDSWITH
ENUM
ERRORS
ESCAPED
EXISTS
EXIT
EXP
EXPLAIN
EXTENDS
FALSE
FETCH
FIELDS
FINAL
FINALLY
FIND
FIRST_NAME
FLOAT
FLOAT4
FLOAT8
FLOOR
FOR
FORCE
FOREIGN
FROM
FULLTEXT
FUNCTION
GENERAL
GEOMETRY
GOTO
GOTO
GRANT
GROUP
HASH
HAVING
HELP
HIGH_PRIORITY
HISTORY
HOUR
HOUR_MICROSECOND
HOUR_MINUTE
HOUR_SECOND
ID
IF
IF
IGNORE
IGNORE_SERVER_IDS
IMPLEMENTS
IMPORT
IN
INDEX
INFILE
INNER
INNODB
INOUT
INSENSITIVE
INSERT
INSTANCEOF
INT
INT1
INT2
INT3
INT4
INT8
INTEGER
INTERFACE
INTERVAL
INTO
IS
ISCHANGED
ISNEW
ISNULL
ITERATE
JOIN
KEY
KEYS
KILL
LABEL 
LAST_MODIFIED_TIMESTAMP
LAST_NAME
LEADING
LEAVE
LEFT
LEN
LIFECYCLE
LIKE
LIMIT
LINEAR                 
LINES
LN
LOAD
LOCALTIME
LOCALTIMESTAMP
LOCK
LOG
LONG
LONGBLOB
LONGTEXT
LOOP
LOW_PRIORITY
LOWER
MASTER_HEAERBEAT_PERIOD
MASTER_SERVER_ID
MASTER_SSL_VERIFY_SERVER_CERT
MATCH
MAX
MAXVALUE
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MIDDLEINT
MIN
MINUTE
MINUTE_MICROSECOND
MINUTE_SECOND
MOD
MOD
MODIFIED_ID
MODIFIER
MODIFIES
MONTH
MRG_MYISAM
NAME
NATIVE
NATURAL
NEW
NO_WRITE_TO_BINLOG
NOT
NOT
NOW
NULL
NUMERIC
OBJECT_ID
ON
OPPORTUNITIES
OPTIMIZE
OPTION
OPTIONALLY
OR
OR
ORDER
OUT
OUTER
OUTFILE
OWNER
OWNER_ID
OWNER_TEAM_ID
P_KEYWORD
PACKAGE
PLANS
POW
PRECISION
PRICELIST
PRIMARY
PRIOR_NAME
PRIORVALUE
PRIVATE
PRIVILEGES
PROCEDURE
PRODUCTS
PROTECTED
PUBLIC
PURGE
PURPOSE_ACCOUNT
PURPOSE_CASE
PURPOSE_CONTACT
PURPOSE_CONTRACT
PURPOSE_LEAD
PURPOSE_OPPORTUNITY_V2
PURPOSE_PRICE_BOOK
PURPOSE_PRODUCT
PURPOSE_PROJECT
RANGE                 
READ
READ_ONLY       
READ_WRITE
READS
REAL
RECORD
REFERENCES
REGEXP
RELEASE
RENAME
REPEAT
REPLACE
REPLACE
REQUIRE
RESIGNAL
RESTRICT
RETURN
RETURNS
REVOKE
RIGHT
RLIKE
ROUND
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
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
STRAIGHT_JOIN
STRICTFP
STRIPED
SUBSTRING
SUPER
SWITCH
SYNCHRONIZED
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
USING
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
VALUE
VALUES
VARBINARY
VARCHAR
VARCHARACTER
VARYING
VOID
VOLATILE
WARNINGS
WEEKDAY
WHEN
WHERE
WHILE
WITH
WORKFLOW_HISTORY
WRITE
XOR
YEAR
YEAR_MONTH
ZEROFILL