Difference between revisions of "Reserved Words"

From AgileApps Support Wiki
Tags: Manual revert Reverted
Tag: Manual revert
 
Line 3: Line 3:
:{|  
:{|  
| valign="top" | <pre>A
| valign="top" | <pre>A
ABS
ABSTRACT
ABSTRACT
ACCESSIBLE
ACCESSIBLE
Line 12: Line 11:
ALTER
ALTER
ANALYZE
ANALYZE
AND
AND
AND
APPOINTMENTS
APPOINTMENTS
Line 43: Line 41:
CHARACTER
CHARACTER
CHECK
CHECK
CLASS
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
DEFAULT
DELAYED
DELAYED
DELETE
DELETE
DENSE_RANK        
DESC
DESC
DESCRIBE
DESCRIBE
Line 108: Line 107:
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 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 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 161: Line 164:
HOUR_SECOND
HOUR_SECOND
ID
ID
IF
IF
IF
IGNORE
IGNORE
Line 184: Line 186:
INTEGER
INTEGER
INTERFACE
INTERFACE
INTERSECT        
INTERVAL
INTERVAL
INTO
INTO
IO_AFTER_GTIDS    
IO_BEFORE_GTIDS    
IS
IS
ISCHANGED
ISCHANGED
Line 192: 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 219: Line 229:
LOW_PRIORITY
LOW_PRIORITY
LOWER
LOWER
MASTER_BIND        
MASTER_HEAERBEAT_PERIOD
MASTER_HEAERBEAT_PERIOD
MASTER_SERVER_ID
MASTER_SERVER_ID
Line 225: Line 236:
MAX
MAX
MAXVALUE
MAXVALUE
MAXVALUE        
MEDIUMBLOB
MEDIUMBLOB
MEDIUMINT
MEDIUMINT
Line 233: Line 245:
MINUTE_MICROSECOND
MINUTE_MICROSECOND
MINUTE_SECOND
MINUTE_SECOND
MOD
MOD
MOD
MODIFIED_ID
MODIFIED_ID
Line 245: Line 256:
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 262: Line 275:
OUTER
OUTER
OUTFILE
OUTFILE
OVER            
OWNER
OWNER
OWNER_ID
OWNER_ID
Line 267: Line 281:
P_KEYWORD
P_KEYWORD
PACKAGE
PACKAGE
PARTITION        
PERCENT_RANK    
PLANS
PLANS
POW
POW
Line 282: Line 298:
PURGE
PURGE
PURPOSE_ACCOUNT
PURPOSE_ACCOUNT
</pre>
| valign="top" | <pre>GROUP
PURPOSE_CASE
PURPOSE_CASE
PURPOSE_CONTACT
PURPOSE_CONTACT
Line 291: Line 309:
PURPOSE_PROJECT
PURPOSE_PROJECT
RANGE                 
RANGE                 
RANK            
READ
READ
READ_ONLY       
READ_ONLY       
Line 297: Line 316:
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 314: Line 332:
RLIKE
RLIKE
ROUND
ROUND
ROW                
ROW_NUMBER        
ROWS            
RTREE
RTREE
S
S
Line 338: Line 359:
SIGN_HASH_PROJECT
SIGN_HASH_PROJECT
SIGNAL
SIGNAL
SIGNAL            
SIGNED_BY_ACCOUNT
SIGNED_BY_ACCOUNT
SIGNED_BY_CASE
SIGNED_BY_CASE
Line 376: Line 398:
STARTSWITH
STARTSWITH
STATIC
STATIC
STORED            
STRAIGHT_JOIN
STRAIGHT_JOIN
STRICTFP
STRICTFP
Line 383: Line 406:
SWITCH
SWITCH
SYNCHRONIZED
SYNCHRONIZED
SYSTEM            
T
T
TABLE
TABLE
Line 423: Line 447:
USERID
USERID
USERPRIMARYTEAMID
USERPRIMARYTEAMID
</pre>
| valign="top" | <pre>GROUP
USING
USING
UTC_DATE
UTC_DATE
Line 433: Line 459:
VARCHARACTER
VARCHARACTER
VARYING
VARYING
VIRTUAL            
VOID
VOID
VOLATILE
VOLATILE
Line 440: 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