ANSI SQL reserved words

These are ANSI SQL keywords that are not reserved by Adaptive Server.

Words

A

absolute, action, allocate, are, assertion

B

bit, bit_length, both

C

cascaded, case, cast, catalog, char, char_length, character, character_length, coalesce, collate, collation, column, connection, constraints, corresponding, cross, current_date, current_time, current_timestamp, current_user

D

date, day, dec, decimal, deferrable, deferred, describe, descriptor, diagnostics, disconnect, domain

E

end-exec, exception, extract

F

false, first, float, found, full

G

get, global, go

H

hour

I

immediate, indicator, initially, inner, input, insensitive, int, integer, interval

J

join

L

language, last, leading, left, local, lower

M

match, minute, module, month

N

names, natural, nchar, next, no, nullif, numeric

O

octet_length, outer, output, overlaps

P

pad, partial, position, preserve, prior

R

real, relative, restrict, right

S

scroll, second, section, semi_sensitive, session_user , size , smallint, space, sql, sqlcode, sqlerror, sqlstate, substring, system_user

T

then, time, timestamp, timezone_hour, timezone_minute, trailing, translate, translation, trim, true

U

unknown, upper, usage

V

value, varchar

W

when, whenever, write, year

Z

zone