D3 SQL reserved words

These words are reserved for use in SQL and ODBC function calls. They should not be used for account names. If these words are found in file names or attribute-defining item names, the name will be prefixed with RSV_ in the resulting SQL table.

A

absolute, action, add, allocate, alter, and, any, are, as, asc, assertion, at, authorization, avg

B

begin, between, bit, bit_length, both, by

C

cascade, cascaded, case, cast, catalog, char, character, char_length, character_length, check, close, coalesce, collate, collation, column, commit, connect, connection, constraint, constraints, continue, convert, corresponding, count, create, cross, current, current_date, current_time, current_timestamp, current_user, cursor

D

date, day, deallocate, dec, decimal, declare, default, deferrable, deferred, delete, desc, describe, descriptor, diagnostics, disconnect, distinct, domain, double, drop

E

else, end, end-exec, escape, except, exception, exec, execute

F

false, fetch, first, float, for, foreign, found, from, full

G

get, global, go, goto, grant, group

I

identity, immediate, in, indicator, initially, inner, input, insensitive, insert, int, integer, intersect, interval, into, is, isolation

J

join

K

key

L

language, last, leading, level, like, local, lower

M

match, max, min, minute, module, month,

N

names, national, natural, nchar, next, no, not, null, ,nullif, numeric

O

octet_length, of, on, only, open, option, or, order, outer, output, overlaps

P

partial, position, precision, prepare, preserve, primary, prior, privileges, procedure, public

R

read, real, references, relative, restrict, revoke, right, rollback, rows

S

schema, scroll, second, section, select, session, session_user, set, size, smallint, some, sql, sqlcode, sqlerror, sqlstate, substring, sum, system_user

T

table, temporary, then, time, timestamp, timezone_hour, timezone_minute, to, trailing, transaction, translate, translation, trim, true

U

union, unique, unknown, update, upper, usage, user, using

V

value, values, varchar, varying, view

W

when, whenever, where, with, work, write

Y

year

Z

zone