Field Naming Rules

Rules

• Field names must start with an alphabetic character.
• Field names can contain only alphabetic characters (A-Z), numeric characters (0-9), and underscores (_)
• Field names cannot be one of the Reserved Words
• Field names must be unique within the object. (They cannot duplicate the name of any other field defined for that object.)

Reserved Words

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