DocumentationAPI Reference
Documentation

Reserved column names

Avoiding reserved column names

Some reserved keywords cannot be used as column names do to reserved statuses in common destination systems. There are 334:

1-6768-134135-201202-268269-334
ACCESSIBLEDEFERRABLEINOUTNULLSMALLINT
ACCOUNTDEFINEINSENSITIVENULLSSOME
ADDDELAYEDINSERTNUMERICSPATIAL
ALLDELETEINTOFSPECIFIC
ALTERDENSE_RANKINT1OFFSETSQL
ANALYSEDESCINT2ONSQL_BIG_RESULT
ANALYZEDESCRIBEINT3ONLYSQL_CALC_FOUND_ROWS
ANDDETERMINISTICINT4OPTIMIZESQL_SMALL_RESULT
ANTIDISTINCTINT8OPTIMIZER_COSTSSQLEXCEPTION
ANYDISTINCTROWINTEGEROPTIONSQLSTATE
ARRAYDIVINTERSECTOPTIONALLYSQLWARNING
ASDOINTERVALORSSL
ASCDOUBLEINTOORDERSTART
ASENSITIVEDROPIO_AFTER_GTIDSORGANIZATIONSTARTING
ASSERT_ROWS_MODIFIEDDUALIO_BEFORE_GTIDSOUTSTORED
ASYMMETRICEACHISOUTERSTRAIGHT_JOIN
ATELSEISNULLOUTFILESTRUCT
AUTHORIZATIONELSEIFISSUEOVERSYMMETRIC
BEFOREEMPTYITERATEOVERLAPSSYSTEM
BETWEENENCLOSEDJOINPARTITIONTABLE
BIGINTENDJSON_TABLEPERCENT_RANKTABLESAMPLE
BINARYENUMKEYPLACINGTERMINATED
BLOBESCAPEKEYSPRECEDINGTHEN
BOTHESCAPEDKILLPRECISIONTINYBLOB
BYEXCEPTLAGPRIMARYTINYINT
CALLEXCLUDELAST_VALUEPROCEDURETINYTEXT
CASCADEEXISTSLATERALPROTOTO
CASEEXITLEADPURGETRAILING
CASTEXPLAINLEADINGQUALIFYTREAT
CHANGEEXTRACTLEAVERANGETRIGGER
CHARFALSELEFTRANKTRUE
CHARACTERFETCHLIKEREADUNBOUNDED
CHECKFIRST_VALUELIMITREAD_WRITEUNDO
COLLATEFLOATLINEARREADSUNION
COLLATIONFLOAT4LINESREALUNIQUE
COLUMNFLOAT8LOADRECURSIVEUNLOCK
CONCURRENTLYFOLLOWINGLOCALTIMEREFERENCESUNNEST
CONDITIONFORLOCALTIMESTAMPREGEXPUNSIGNED
CONNECTFORCELOCKRELEASEUPDATE
CONNECTIONFOREIGNLONGRENAMEUSAGE
CONSTRAINTFREEZELONGBLOBREPEATUSE
CONTAINSFROMLONGTEXTREPLACEUSER
CONTINUEFULLLOOKUPREQUIREUSING
CONVERTFULLTEXTLOOPRESIGNALUTC_DATE
CREATEFUNCTIONLOW_PRIORITYRESTRICTUTC_TIME
CROSSGENERATEDMASTER_BINDRETURNUTC_TIMESTAMP
CUBEGETMASTER_SSL_VERIFY_SERVER_CERTRETURNINGVALUES
CUME_DISTGRANTMATCHREVOKEVARBINARY
CURRENTGROUPMAXVALUERIGHTVARCHAR
CURRENT_CATALOGGROUPINGMEDIUMBLOBRLIKEVARCHARACTER
CURRENT_DATEGROUPSMEDIUMINTROLLUPVARIADIC
CURRENT_ROLEGSCLUSTERMEDIUMTEXTROWVARYING
CURRENT_SCHEMAHASHMERGEROW_NUMBERVERBOSE
CURRENT_TIMEHAVINGMIDDLEINTROWSVIEW
CURRENT_TIMESTAMPHIGH_PRIORITYMINUSSAMPLEVIRTUAL
CURRENT_USERHOUR_MICROSECONDMINUTE_MICROSECONDSCHEMAWHEN
CURSORHOUR_MINUTEMINUTE_SECONDSCHEMASWHENEVER
DATABASEHOUR_SECONDMODSECOND_MICROSECONDWHERE
DATABASESIFMODIFIESSELECTWHILE
DAY_HOURIGNORENATURALSEMIWINDOW
DAY_MICROSECONDILIKENEWSENSITIVEWITH
DAY_MINUTEINNOSEPARATORWITHIN
DAY_SECONDINCREMENTNO_WRITE_TO_BINLOGSESSION_USERWRITE
DECINDEXNOTSETXOR
DECIMALINFILENOTNULLSHOWYEAR_MONTH
DECLAREINITIALLYNTH_VALUESIGNALZEROFILL
DEFAULTINNERNTILESIMILAR``