Зарезервированные слова

Слова, перечисленные ниже, зарезервированы системой и поддерживаемыми СУБД в служебных целях.

Зарезервированные слова не могут использоваться как имена (идентификаторы) логических сущностей и столбцов.

A

abs, all, allocate, allow, alter, and, any, are, array, array_max_cardinality, as, asensitive, asymmetric, at, atomic, authorization, avg

B

begin, begin_frame, begin_partition, between, bigint, binary, bit, blob, boolean, both, bucket_id, by

C

call, called, cardinality, cascaded, case, cast, ceil, ceiling, char, character, character_length, char_length, check, classifier, clob, close, coalesce, collate, collect, column, commit, condition, connect, constraint, contains, convert, corr, corresponding, count, covar_pop, covar_samp, create, cross, cube, cume_dist, current, current_catalog, current_date, current_default_transform_group, current_path, current_role, current_row, current_schema, current_time, current_timestamp, current_transform_group_for_type, current_user, cursor, cycle

D

date, day, deallocate, dec, decimal, declare, default, define, delete, dense_rank, deref, describe, deterministic, disallow, disconnect, distinct, double, drop, dynamic

E

each, element, else, empty, end, end-exec, end_frame, end_partition, equals, escape, every, except, exec, execute, exists, exp, explain, extend, external, extract

F

false, fetch, filter, first_value, float, floor, for, foreign, frame_row, free, from, full, function, fusion

G

get, global, grant, group, grouping, groups

H

having, hold, hour

I

identity, import, in, indicator, initial, inner, inout, insensitive, insert, int, integer, intersect, intersection, interval, into, is

J

join, json_array, json_arrayagg, json_exists, json_object, json_objectagg, json_query, json_value

L

lag, language, large, last_value, lateral, lead, leading, left, like, like_regex, limit, ln, local, localtime, localtimestamp, lower

M

match, matches, match_number, match_recognize, max, measures, member, merge, method, min, minus, minute, mod, modifies, module, month, multiset

N

national, natural, nchar, nclob, new, next, no, none, normalize, not, nth_value, ntile, null, nullif, numeric

O

occurrences_regex, octet_length, of, offset, old, omit, on, one, only, open, or, order, out, outer, over, overlaps, overlay

P

parameter, partition, pattern, per, percent, percentile_cont, percentile_disc, percent_rank, period, permute, portion, position, position_regex, power, precedes, precision, prepare, prev, primary, procedure

R

range, rank, reads, real, recursive, ref, references, referencing, regr_avgx, regr_avgy, regr_count, regr_intercept, regr_r2, regr_slope, regr_sxx, regr_sxy, regr_syy, release, reset, result, return, returns, revoke, right, rollback, rollup, row, row_number, rows, running

S

savepoint, scope, scroll, search, second, seek, select, sensitive, session_user, set, show, sign, similar, skip, smallint, some, specific, specifictype, sql, sqlexception, sqlstate, sqlwarning, sqrt, start, static, stddev_pop, stddev_samp, stream, submultiset, subset, substring, substring_regex, succeeds, sum, symmetric, sys_close_date, sys_from, sys_op, system, system_time, system_user, sys_to

T

table, tablesample, then, time, timestamp, timezone_hour, timezone_minute, tinyint, to, trailing, translate, translate_regex, translation, treat, trigger, trim, trim_array, true, truncate, tumble

U

uescape, union, unique, unknown, unnest, update, upper, upsert, user, using

V

value, value_of, values, varbinary, varchar, var_pop, var_samp, varying, versioning

W

when, whenever, where, width_bucket, window, with, within, without

Y

year