Reserved column names
Avoiding reserved column names
Some reserved keywords cannot be used as column names due to reserved statuses in common destination systems. There are 334:
1-67 | 68-134 | 135-201 | 202-268 | 269-334 |
---|---|---|---|---|
ACCESSIBLE | DEFERRABLE | INOUT | NULL | SMALLINT |
ACCOUNT | DEFINE | INSENSITIVE | NULLS | SOME |
ADD | DELAYED | INSERT | NUMERIC | SPATIAL |
ALL | DELETE | INT | OF | SPECIFIC |
ALTER | DENSE_RANK | INT1 | OFFSET | SQL |
ANALYSE | DESC | INT2 | ON | SQL_BIG_RESULT |
ANALYZE | DESCRIBE | INT3 | ONLY | SQL_CALC_FOUND_ROWS |
AND | DETERMINISTIC | INT4 | OPTIMIZE | SQL_SMALL_RESULT |
ANTI | DISTINCT | INT8 | OPTIMIZER_COSTS | SQLEXCEPTION |
ANY | DISTINCTROW | INTEGER | OPTION | SQLSTATE |
ARRAY | DIV | INTERSECT | OPTIONALLY | SQLWARNING |
AS | DO | INTERVAL | OR | SSL |
ASC | DOUBLE | INTO | ORDER | START |
ASENSITIVE | DROP | IO_AFTER_GTIDS | ORGANIZATION | STARTING |
ASSERT_ROWS_MODIFIED | DUAL | IO_BEFORE_GTIDS | OUT | STORED |
ASYMMETRIC | EACH | IS | OUTER | STRAIGHT_JOIN |
AT | ELSE | ISNULL | OUTFILE | STRUCT |
AUTHORIZATION | ELSEIF | ISSUE | OVER | SYMMETRIC |
BEFORE | EMPTY | ITERATE | OVERLAPS | SYSTEM |
BETWEEN | ENCLOSED | JOIN | PARTITION | TABLE |
BIGINT | END | JSON_TABLE | PERCENT_RANK | TABLESAMPLE |
BINARY | ENUM | KEY | PLACING | TERMINATED |
BLOB | ESCAPE | KEYS | PRECEDING | THEN |
BOTH | ESCAPED | KILL | PRECISION | TINYBLOB |
BY | EXCEPT | LAG | PRIMARY | TINYINT |
CALL | EXCLUDE | LAST_VALUE | PROCEDURE | TINYTEXT |
CASCADE | EXISTS | LATERAL | PROTO | TO |
CASE | EXIT | LEAD | PURGE | TRAILING |
CAST | EXPLAIN | LEADING | QUALIFY | TREAT |
CHANGE | EXTRACT | LEAVE | RANGE | TRIGGER |
CHAR | FALSE | LEFT | RANK | TRUE |
CHARACTER | FETCH | LIKE | READ | UNBOUNDED |
CHECK | FIRST_VALUE | LIMIT | READ_WRITE | UNDO |
COLLATE | FLOAT | LINEAR | READS | UNION |
COLLATION | FLOAT4 | LINES | REAL | UNIQUE |
COLUMN | FLOAT8 | LOAD | RECURSIVE | UNLOCK |
CONCURRENTLY | FOLLOWING | LOCALTIME | REFERENCES | UNNEST |
CONDITION | FOR | LOCALTIMESTAMP | REGEXP | UNSIGNED |
CONNECT | FORCE | LOCK | RELEASE | UPDATE |
CONNECTION | FOREIGN | LONG | RENAME | USAGE |
CONSTRAINT | FREEZE | LONGBLOB | REPEAT | USE |
CONTAINS | FROM | LONGTEXT | REPLACE | USER |
CONTINUE | FULL | LOOKUP | REQUIRE | USING |
CONVERT | FULLTEXT | LOOP | RESIGNAL | UTC_DATE |
CREATE | FUNCTION | LOW_PRIORITY | RESTRICT | UTC_TIME |
CROSS | GENERATED | MASTER_BIND | RETURN | UTC_TIMESTAMP |
CUBE | GET | MASTER_SSL_VERIFY_SERVER_CERT | RETURNING | VALUES |
CUME_DIST | GRANT | MATCH | REVOKE | VARBINARY |
CURRENT | GROUP | MAXVALUE | RIGHT | VARCHAR |
CURRENT_CATALOG | GROUPING | MEDIUMBLOB | RLIKE | VARCHARACTER |
CURRENT_DATE | GROUPS | MEDIUMINT | ROLLUP | VARIADIC |
CURRENT_ROLE | GSCLUSTER | MEDIUMTEXT | ROW | VARYING |
CURRENT_SCHEMA | HASH | MERGE | ROW_NUMBER | VERBOSE |
CURRENT_TIME | HAVING | MIDDLEINT | ROWS | VIEW |
CURRENT_TIMESTAMP | HIGH_PRIORITY | MINUS | SAMPLE | VIRTUAL |
CURRENT_USER | HOUR_MICROSECOND | MINUTE_MICROSECOND | SCHEMA | WHEN |
CURSOR | HOUR_MINUTE | MINUTE_SECOND | SCHEMAS | WHENEVER |
DATABASE | HOUR_SECOND | MOD | SECOND_MICROSECOND | WHERE |
DATABASES | IF | MODIFIES | SELECT | WHILE |
DAY_HOUR | IGNORE | NATURAL | SEMI | WINDOW |
DAY_MICROSECOND | ILIKE | NEW | SENSITIVE | WITH |
DAY_MINUTE | IN | NO | SEPARATOR | WITHIN |
DAY_SECOND | INCREMENT | NO_WRITE_TO_BINLOG | SESSION_USER | WRITE |
DEC | INDEX | NOT | SET | XOR |
DECIMAL | INFILE | NOTNULL | SHOW | YEAR_MONTH |
DECLARE | INITIALLY | NTH_VALUE | SIGNAL | ZEROFILL |
DEFAULT | INNER | NTILE | SIMILAR | `` |
Updated 4 months ago