Difference between revisions of "Reserved Words"

From AgileApps Support Wiki
imported>Aeric
Β 
imported>Aeric
Line 1: Line 1:
:These words are used within the platform internally, and cannot be used for names:
These words are used within the platform internally, and cannot be used for names.
:See also: [[Reserved Words by Group]]
:{| Β 
:{| Β 
| valign="top" | <pre>ACCESSIBLE Β  Β  Β 
| valign="top" | <pre>A
ABS
ABSTRACT
ACCESSIBLE
ACTIVITIES
ADD
ADD
AFFILIATE_ID
ALL
ALL
ALTER
ALTER
ANALYZE
ANALYZE
AND
AND
AND
APPOINTMENTS
AS
AS
ASC
ASC
ASENSITIVE
ASENSITIVE
ASSERT
AUTO_INCREMENT
BDB
BEFORE
BEFORE
BETWEEN
BETWEEN
Line 15: Line 26:
BINARY
BINARY
BLOB
BLOB
BOOLEAN
BOTH
BOTH
BREAK
BTREE
BY
BY
BYTE
CALL
CALL
CAMPAIGNS
CASCADE
CASCADE
CASE
CASE
CASES
CATCH
CEIL
CHANGE
CHANGE
CHAR
CHAR
CHARACTER
CHARACTER
CHECK
CHECK
CLASS
CLASS
COFF
COLLATE
COLLATE
COLUMN
COLUMN
COLUMNS
COMMENTS
CONCAT
CONDITION
CONDITION
CONNECTION
CONNECTION
CONST
CONSTRAINT
CONSTRAINT
contact_email
contact_fax
contact_first_name
contact_last_name
contact_mobile_phone
contact_phone
contact_title
CONTACTS
CONTAINS
CONTINUE
CONTINUE
CONTRACTS
CONVERT
CONVERT
CREATE
CREATE
CREATED_ID
CREATOR
CRITERIA
CROSS
CROSS
CURRENT_DATE
CURRENT_DATE
Line 38: Line 77:
CURRENT_USER
CURRENT_USER
CURSOR
CURSOR
CUSTOMER_ID
DATABASE
DATABASE
DATABASES
DATABASES
DATE
DATE_CREATED
DATE_MODIFIED
DATEADD
DATECOMP
DATESUB
DATEVALUE
DAY
DAY_HOUR
DAY_HOUR
DAY_MICROSECOND
DAY_MICROSECOND
Line 47: Line 95:
DECIMAL
DECIMAL
DECLARE
DECLARE
DEFAULT
DEFAULT
DEFAULT
DELAYED
DELAYED
Line 56: Line 105:
DISTINCTROW
DISTINCTROW
DIV
DIV
DO
DOCUMENTS
DONE
DOUBLE
DOUBLE
DOUBLE
DROP
DROP
DUAL
DUAL
EACH
EACH
ELSE
ELSE
ELSE
ELSEIF
ELSEIF
EMAIL_ACTIVITIES
ENCLOSED
ENCLOSED
ENDSWITH
ENUM
ERRORS
ESCAPED
ESCAPED
EXISTS
EXISTS
EXIT
EXIT
EXP
EXPLAIN
EXPLAIN
EXTENDS
FALSE
FALSE
FETCH
FETCH
FIELDS
FINAL
FINALLY
FIND
FIRST_NAME
FLOAT
FLOAT
FLOAT4
FLOAT4
FLOAT8
FLOAT8
FLOOR
FOR
FOR
FORCE
FORCE
Line 77: Line 143:
FROM
FROM
FULLTEXT
FULLTEXT
FUNCTION
GEOMETRY
GOTO
GOTO
GOTO
GRANT
GRANT
GROUP
</pre>
| valign="top" | <pre>GROUP
HASH
HAVING
HAVING
HELP
HIGH_PRIORITY
HIGH_PRIORITY
HISTORY
HOUR
HOUR_MICROSECOND
HOUR_MICROSECOND
HOUR_MINUTE
HOUR_MINUTE
HOUR_SECOND
HOUR_SECOND
ID
IF
IF
IF
IGNORE
IGNORE
IMPLEMENTS
IMPORT
IN
IN
INDEX
INDEX
INFILE
INFILE
INNER
INNER
INNODB
INOUT
INOUT
INSENSITIVE
INSENSITIVE
INSERT
INSERT
INSTANCEOF
INT
INT
INT1
INT1
Line 101: Line 181:
INT8
INT8
INTEGER
INTEGER
INTERFACE
INTERVAL
INTERVAL
INTO
INTO
IS
IS
ISCHANGED
ISNEW
ISNULL
ITERATE
ITERATE
JOIN
JOIN
Line 110: Line 194:
KILL
KILL
LABEL Β 
LABEL Β 
LAST_MODIFIED_TIMESTAMP
LAST_NAME
LEADING
LEADING
LEAVE
LEAVE
LEFT
LEFT
LEN
LIFECYCLE
LIKE
LIKE
LIMIT
LIMIT
LINEARΒ  Β  Β  Β  Β  Β  Β  Β  Β 
LINEARΒ  Β  Β  Β  Β  Β  Β  Β  Β 
LINES
LINES
LN
LOAD
LOAD
LOCALTIME
LOCALTIME
LOCALTIMESTAMP
LOCALTIMESTAMP
LOCK
LOCK
LOG
LONG
LONG
LONGBLOB
LONGBLOB
Line 126: Line 216:
LOOP
LOOP
LOW_PRIORITY
LOW_PRIORITY
LOWER
MASTER_SERVER_ID
MASTER_SSL_VERIFY_SERVER_CERT
MASTER_SSL_VERIFY_SERVER_CERT
MATCH
MATCH
MAX
MEDIUMBLOB
MEDIUMBLOB
MEDIUMINT
MEDIUMINT
MEDIUMTEXT
MEDIUMTEXT
MIDDLEINT
MIDDLEINT
MIN
MINUTE
MINUTE_MICROSECOND
MINUTE_MICROSECOND
MINUTE_SECOND
MINUTE_SECOND
MOD
MOD
MOD
MODIFIED_ID
MODIFIER
MODIFIES
MODIFIES
MONTH
MRG_MYISAM
NAME
NATIVE
NATURAL
NATURAL
NEW
NO_WRITE_TO_BINLOG
NOT
NOT
NOT
NO_WRITE_TO_BINLOG
NOW
NULL
NULL
NUMERIC
NUMERIC
OBJECT_ID
ON
ON
OPPORTUNITIES
OPTIMIZE
OPTIMIZE
OPTION
OPTION
OPTIONALLY
OPTIONALLY
OR
OR
OR
ORDER
ORDER
Line 150: Line 258:
OUTER
OUTER
OUTFILE
OUTFILE
OWNER
OWNER_ID
OWNER_TEAM_ID
P_KEYWORD
PACKAGE
PLANS
POW
PRECISION
PRECISION
PRICELIST
PRIMARY
PRIMARY
PRIOR_NAME
PRIORVALUE
PRIVATE
PRIVILEGES
PROCEDURE
PROCEDURE
PRODUCTS
PROTECTED
PUBLIC
PURGE
PURGE
PURPOSE_ACCOUNT
PURPOSE_CASE
PURPOSE_CONTACT
PURPOSE_CONTRACT
PURPOSE_LEAD
PURPOSE_OPPORTUNITY_V2
PURPOSE_PRICE_BOOK
PURPOSE_PRODUCT
PURPOSE_PROJECT
RANGEΒ  Β  Β  Β  Β  Β  Β  Β  Β 
RANGEΒ  Β  Β  Β  Β  Β  Β  Β  Β 
READ
READ
READS
READ_ONLYΒ  Β  Β  Β 
READ_ONLYΒ  Β  Β  Β 
READ_WRITE
READ_WRITE
READS
REAL
REAL
RECORD
REFERENCES
REFERENCES
REGEXP
</pre>
| valign="top" | <pre>REGEXP
RELEASE
RELEASE
RENAME
RENAME
REPEAT
REPEAT
REPLACE
REPLACE
REPLACE
REQUIRE
REQUIRE
RESTRICT
RESTRICT
RETURN
RETURN
RETURNS
REVOKE
REVOKE
RIGHT
RIGHT
RLIKE
RLIKE
ROUND
RTREE
S
SCHEMA
SCHEMA
SCHEMAS
SCHEMAS
SEARCH_STRING
SECOND
SECOND_MICROSECOND
SECOND_MICROSECOND
SELECT
SELECT
Line 179: Line 320:
SEPARATOR
SEPARATOR
SET
SET
SHORT
SHOW
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
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
SMALLINT
SMALLINT
SOME
SONAME
SONAME
SOURCEPAGE
SPATIAL
SPATIAL
SPECIFIC
SPECIFIC
SPENDING
SQL
SQL
SQL_BIG_RESULT
SQL_BIG_RESULT
SQL_CALC_FOUND_ROWS
SQL_CALC_FOUND_ROWS
SQL_SMALL_RESULT
SQLEXCEPTION
SQLEXCEPTION
SQL_SMALL_RESULT
SQLSTATE
SQLSTATE
SQLWARNING
SQLWARNING
SQRT
SSL
SSL
STARTING
STARTING
STARTSWITH
STATIC
STRAIGHT_JOIN
STRAIGHT_JOIN
STRICTFP
STRIPED
SUBSTRING
SUPER
SWITCH
SYNCHRONIZED
T
TABLE
TABLE
TABLES
TAGLIST
TARGETPAGE
TERMINATED
TERMINATED
TEXT
THEN
THEN
THIS
THROW
THROWS
TIME
TIMEVALUE
TINYBLOB
TINYBLOB
TINYINT
TINYINT
TINYTEXT
TINYTEXT
TO
TO
TODAY
TOP_TAB
TRAILING
TRAILING
TRANSIENT
TRIGGER
TRIGGER
TRIM
TRUE
TRUE
TRY
TYPES
UNDO
UNDO
UNION
UNION
Line 211: Line 409:
UPDATE
UPDATE
UPGRADE
UPGRADE
UPPER
USAGE
USAGE
USE
USE
USER
USER_RESOURCES
USERID
USERPRIMARYTEAMID
USING
USING
UTC_DATE
UTC_DATE
UTC_TIME
UTC_TIME
UTC_TIMESTAMP
UTC_TIMESTAMP
VALUE
VALUES
VALUES
VARBINARY
VARBINARY
Line 222: Line 426:
VARCHARACTER
VARCHARACTER
VARYING
VARYING
VOID
VOLATILE
WARNINGS
WEEKDAY
WHEN
WHEN
WHERE
WHERE
WHILE
WHILE
WITH
WITH
WORKFLOW_HISTORY
WRITE
WRITE
XOR
XOR
YEAR
YEAR_MONTH
YEAR_MONTH
ZEROFILL</pre>
ZEROFILL
| valign="top" | <pre>AUTO_INCREMENT
</pre>
BDB
BTREE
COLUMNS
DATE
ERRORS
FIELDS
FUNCTION
GEOMETRY
HASH
HELP
INNODB
MASTER_SERVER_ID
MRG_MYISAM
PRIVILEGES
RETURNS
RTREE
SOME
STRIPED
TABLES
TYPES
USER_RESOURCES
WARNINGS
Β 
A
CLASS
COFF
CREATED_ID
CRITERIA
DATE_CREATED
DATE_MODIFIED
DONE
ID
NAME
PRIOR_NAME
MODIFIED_ID
OBJECT_ID
OWNER_ID
OWNER_TEAM_ID
P_KEYWORD
S
SEARCH_STRING
SHOW_LAYOUT
SOURCEPAGE
T
TARGETPAGE
TOP_TAB
FIRST_NAME
LAST_NAME
USERPRIMARYTEAMID
CUSTOMER_ID
USERID
AFFILIATE_ID
USER
OWNER
MODIFIER
CREATOR
LAST_MODIFIED_TIMESTAMP
Β 
WORKFLOW_HISTORY
DOCUMENTS
OPPORTUNITIES
ACTIVITIES
CONTACTS
CASES
CONTRACTS
CAMPAIGNS
SPENDING
PRODUCTS
HISTORY
COMMENTS
LIFECYCLE
PLANS
PRICELIST
TAGLIST
APPOINTMENTS
EMAIL_ACTIVITIES
RECORD
Β 
Β 
ABS
CEIL
EXP
FLOOR
LN
LOG
MAX
MIN
MOD
POW
ROUND
SQRT
CONCAT
CONTAINS
ENDSWITH
FIND
LEN
LOWER
REPLACE
STARTSWITH
SUBSTRING
TEXT
TRIM
UPPER
VALUE
DATEADD
DATECOMP
DATESUB
DATEVALUE
DAY
HOUR
MINUTE
MONTH
NOW
SECOND
TODAY
TIME
TIMEVALUE
WEEKDAY
YEAR
AND
IF
ISNULL
NOT
OR
PRIORVALUE
ISNEW
ISCHANGED</pre>
| valign="top" | <pre>SIGNED_BY_ACCOUNT
SIGNED_BY_DATE_ACCOUNT
SIGN_HASH_ACCOUNT
PURPOSE_ACCOUNT
Β 
SIGNED_BY_LEAD
SIGNED_BY_DATE_LEAD
SIGN_HASH_LEAD
PURPOSE_LEAD
Β 
SIGNED_BY_CONTACT
SIGNED_BY_DATE_CONTACT
SIGN_HASH_CONTACT
PURPOSE_CONTACT
Β 
SIGNED_BY_CONTRACT
SIGNED_BY_DATE_CONTRACT
SIGN_HASH_CONTRACT
PURPOSE_CONTRACT
Β 
SIGNED_BY_CASE
SIGNED_BY_DATE_CASE
SIGN_HASH_CASE
PURPOSE_CASE
Β 
SIGNED_BY_OPPORTUNITY_V2
SIGNED_BY_DATE_OPPORTUNITY_V2
SIGN_HASH_OPPORTUNITY_V2
PURPOSE_OPPORTUNITY_V2
Β 
SIGNED_BY_PROJECT
SIGNED_BY_DATE_PROJECT
SIGN_HASH_PROJECT
PURPOSE_PROJECT
Β 
SIGNED_BY_PRODUCT
SIGNED_BY_DATE_PRODUCT
SIGN_HASH_PRODUCT
PURPOSE_PRODUCT
Β 
SIGNED_BY_PRICE_BOOK
SIGNED_BY_DATE_PRICE_BOOK
SIGN_HASH_PRICE_BOOK
PURPOSE_PRICE_BOOK
Β 
contact_first_name
contact_last_name
contact_phone
contact_mobile_phone
contact_fax
contact_email
contact_title
Β 
ABSTRACT
NEW
SWITCH
ASSERT
DEFAULT
GOTO
PACKAGE
SYNCHRONIZED
BOOLEAN
DO
PRIVATE
THIS
BREAK
DOUBLE
IMPLEMENTS
PROTECTED
THROW
BYTE
ELSE
IMPORT
PUBLIC
THROWS
ENUM
INSTANCEOF
TRANSIENT
CATCH
EXTENDS
SHORT
TRY
FINAL
INTERFACE
STATIC
VOID
CLASS
FINALLY
STRICTFP
VOLATILE
CONST
NATIVE
SUPER</pre>
|}
|}

Revision as of 23:46, 10 November 2011

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
GEOMETRY
GOTO
GOTO
GRANT
GROUP
HASH
HAVING
HELP
HIGH_PRIORITY
HISTORY
HOUR
HOUR_MICROSECOND
HOUR_MINUTE
HOUR_SECOND
ID
IF
IF
IGNORE
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_SERVER_ID
MASTER_SSL_VERIFY_SERVER_CERT
MATCH
MAX
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
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
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
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