Search…
OmniSci Reserved Words
Following is a list of OmniSci keywords.
1
ABS
2
ACCESS
3
ADD
4
ALL
5
ALLOCATE
6
ALLOW
7
ALTER
8
AMMSC
9
AND
10
ANY
11
ARCHIVE
12
ARE
13
ARRAY_MAX_CARDINALITY
14
ARRAY
15
AS
16
ASC
17
ASENSITIVE
18
ASYMMETRIC
19
AT
20
ATOMIC
21
AUTHORIZATION
22
AVG
23
BEGIN
24
BEGIN_FRAME
25
BEGIN_PARTITION
26
BETWEEN
27
BIGINT
28
BINARY
29
BIT
30
BLOB
31
BOOLEAN
32
BOTH
33
BY
34
CALL
35
CALLED
36
CARDINALITY
37
CASCADED
38
CASE
39
CAST
40
CEIL
41
CEILING
42
CHAR
43
CHARACTER
44
CHARACTER_LENGTH
45
CHAR_LENGTH
46
CHECK
47
CLASSIFIER
48
CLOB
49
CLOSE
50
COALESCE
51
COLLATE
52
COLLECT
53
COLUMN
54
COMMIT
55
CONDITION
56
CONNECT
57
CONSTRAINT
58
CONTAINS
59
CONTINUE
60
CONVERT
61
COPY
62
CORR
63
CORRESPONDING
64
COUNT
65
COVAR_POP
66
COVAR_SAMP
67
CREATE
68
CROSS
69
CUBE
70
CUME_DIST
71
CURRENT
72
CURRENT_CATALOG
73
CURRENT_DATE
74
CURRENT_DEFAULT_TRANSFORM_GROUP
75
CURRENT_PATH
76
CURRENT_ROLE
77
CURRENT_ROW
78
CURRENT_SCHEMA
79
CURRENT_TIME
80
CURRENT_TIMESTAMP
81
CURRENT_TRANSFORM_GROUP_FOR_TYPE
82
CURRENT_USER
83
CURSOR
84
CYCLE
85
DASHBOARD
86
DATABASE
87
DATE
88
DATE_TRUNC
89
DATETIME
90
DAY
91
DEALLOCATE
92
DEC
93
DECIMAL
94
DECLARE
95
DEFAULT
96
DEFINE
97
DELETE
98
DENSE_RANK
99
DEREF
100
DESC
101
DESCRIBE
102
DETERMINISTIC
103
DISALLOW
104
DISCONNECT
105
DISTINCT
106
DOUBLE
107
DROP
108
DUMP
109
DYNAMIC
110
EACH
111
EDIT
112
EDITOR
113
ELEMENT
114
ELSE
115
EMPTY
116
END
117
END-EXEC
118
END_FRAME
119
END_PARTITION
120
EQUALS
121
ESCAPE
122
EVERY
123
EXCEPT
124
EXEC
125
EXECUTE
126
EXISTS
127
EXP
128
EXPLAIN
129
EXTEND
130
EXTERNAL
131
EXTRACT
132
FALSE
133
FETCH
134
FILTER
135
FIRST
136
FIRST_VALUE
137
FLOAT
138
FLOOR
139
FOR
140
FOREIGN
141
FOUND
142
FRAME_ROW
143
FREE
144
FROM
145
FULL
146
FUNCTION
147
FUSION
148
GEOGRAPHY
149
GEOMETRY
150
GET
151
GLOBAL
152
GRANT
153
GROUP
154
GROUPING
155
GROUPS
156
HAVING
157
HOLD
158
HOUR
159
IDENTITY
160
IF
161
ILIKE
162
IMPORT
163
IN
164
INDICATOR
165
INITIAL
166
INNER
167
INOUT
168
INSENSITIVE
169
INSERT
170
INT
171
INTEGER
172
INTERSECT
173
INTERSECTION
174
INTERVAL
175
INTO
176
IS
177
JOIN
178
LAG
179
LANGUAGE
180
LARGE
181
LAST_VALUE
182
LAST
183
LATERAL
184
LEAD
185
LEADING
186
LEFT
187
LENGTH
188
LIKE
189
LIKE_REGEX
190
LIMIT
191
LINESTRING
192
LN
193
LOCAL
194
LOCALTIME
195
LOCALTIMESTAMP
196
LOWER
197
MATCH
198
MATCH_NUMBER
199
MATCH_RECOGNIZE
200
MATCHES
201
MAX
202
MEASURES
203
MEMBER
204
MERGE
205
METHOD
206
MIN
207
MINUS
208
MINUTE
209
MOD
210
MODIFIES
211
MODULE
212
MONTH
213
MULTIPOLYGON
214
MULTISET
215
NATIONAL
216
NATURAL
217
NCHAR
218
NCLOB
219
NEW
220
NEXT
221
NO
222
NONE
223
NORMALIZE
224
NOT
225
NOW
226
NTH_VALUE
227
NTILE
228
NULL
229
NULLIF
230
NULLX
231
NUMERIC
232
OCCURRENCES_REGEX
233
OCTET_LENGTH
234
OF
235
OFFSET
236
OLD
237
OMIT
238
ON
239
ONE
240
ONLY
241
OPEN
242
OPTIMIZE
243
OPTION
244
OR
245
ORDER
246
OUT
247
OUTER
248
OVER
249
OVERLAPS
250
OVERLAY
251
PARAMETER
252
PARTITION
253
PATTERN
254
PER
255
PERCENT
256
PERCENT_RANK
257
PERCENTILE_CONT
258
PERCENTILE_DISC
259
PERIOD
260
PERMUTE
261
POINT
262
POLYGON
263
PORTION
264
POSITION
265
POSITION_REGEX
266
POWER
267
PRECEDES
268
PRECISION
269
PREPARE
270
PREV
271
PRIMARY
272
PRIVILEGES
273
PROCEDURE
274
PUBLIC
275
RANGE
276
RANK
277
READS
278
REAL
279
RECURSIVE
280
REF
281
REFERENCES
282
REFERENCING
283
REGR_AVGX
284
REGR_AVGY
285
REGR_COUNT
286
REGR_INTERCEPT
287
REGR_R2
288
REGR_SLOPE
289
REGR_SXX
290
REGR_SXY
291
REGR_SYY
292
RELEASE
293
RENAME
294
RESET
295
RESULT
296
RESTORE
297
RETURN
298
RETURNS
299
REVOKE
300
RIGHT
301
ROLE
302
ROLLBACK
303
ROLLUP
304
ROW
305
ROW_NUMBER
306
ROWS
307
ROWID
308
RUNNING
309
SAVEPOINT
310
SCHEMA
311
SCOPE
312
SCROLL
313
SEARCH
314
SECOND
315
SEEK
316
SELECT
317
SENSITIVE
318
SESSION_USER
319
SET
320
SHOW
321
SIMILAR
322
SKIP
323
SMALLINT
324
SOME
325
SPECIFIC
326
SPECIFICTYPE
327
SQL
328
SQLEXCEPTION
329
SQLSTATE
330
SQLWARNING
331
SQRT
332
START
333
STATIC
334
STDDEV_POP
335
STDDEV_SAMP
336
STREAM
337
SUBMULTISET
338
SUBSET
339
SUBSTRING
340
SUBSTRING_REGEX
341
SUCCEEDS
342
SUM
343
SYMMETRIC
344
SYSTEM
345
SYSTEM_TIME
346
SYSTEM_USER
347
TABLE
348
TABLESAMPLE
349
TEMPORARY
350
TEXT
351
THEN
352
TIME
353
TIMESTAMP
354
TIMEZONE_HOUR
355
TIMEZONE_MINUTE
356
TINYINT
357
TO
358
TRAILING
359
TRANSLATE
360
TRANSLATE_REGEX
361
TRANSLATION
362
TREAT
363
TRIGGER
364
TRIM
365
TRIM_ARRAY
366
TRUE
367
TRUNCATE
368
UESCAPE
369
UNION
370
UNIQUE
371
UNKNOWN
372
UNNEST
373
UPDATE
374
UPPER
375
UPSERT
376
USER
377
USING
378
VALUE
379
VALUE_OF
380
VALUES
381
VARBINARY
382
VARCHAR
383
VAR_POP
384
VAR_SAMP
385
VARYING
386
VERSIONING
387
VIEW
388
WHEN
389
WHENEVER
390
WHERE
391
WIDTH_BUCKET
392
WINDOW
393
WITH
394
WITHIN
395
WITHOUT
396
WORK
397
YEAR
Copied!
Export as PDF
Copy link