2 " Language: SQL, Adaptive Server Anywhere
3 " Maintainer: David Fishburn <fishburn at ianywhere dot com>
4 " Last Change: 2009 Mar 15
7 " Description: Updated to Adaptive Server Anywhere 11.0.1
8 " Updated to Adaptive Server Anywhere 10.0.1
9 " Updated to Adaptive Server Anywhere 9.0.2
10 " Updated to Adaptive Server Anywhere 9.0.1
11 " Updated to Adaptive Server Anywhere 9.0.0
13 " For version 5.x: Clear all syntax items
14 " For version 6.x: Quit when a syntax file was already loaded
17 elseif exists("b:current_syntax")
23 " The SQL reserved words, defined as keywords.
25 syn keyword sqlSpecial false null true
28 syn keyword sqlFunction count sum avg min max debug_eng isnull
29 syn keyword sqlFunction greater lesser argn string ymd todate
30 syn keyword sqlFunction totimestamp date today now utc_now
31 syn keyword sqlFunction number identity years months weeks days
32 syn keyword sqlFunction hours minutes seconds second minute hour
33 syn keyword sqlFunction day month year dow date_format substr
34 syn keyword sqlFunction substring byte_substr length byte_length
35 syn keyword sqlFunction datalength ifnull evaluate list
36 syn keyword sqlFunction soundex similar difference like_start
37 syn keyword sqlFunction like_end regexp_compile
38 syn keyword sqlFunction regexp_compile_patindex remainder abs
39 syn keyword sqlFunction graphical_plan plan explanation ulplan
40 syn keyword sqlFunction graphical_ulplan long_ulplan
41 syn keyword sqlFunction short_ulplan rewrite watcomsql
42 syn keyword sqlFunction transactsql dialect estimate
43 syn keyword sqlFunction estimate_source index_estimate
44 syn keyword sqlFunction experience_estimate traceback wsql_state
45 syn keyword sqlFunction lang_message dateadd datediff datepart
46 syn keyword sqlFunction datename dayname monthname quarter
47 syn keyword sqlFunction tsequal hextoint inttohex rand textptr
48 syn keyword sqlFunction rowid grouping stddev variance rank
49 syn keyword sqlFunction dense_rank density percent_rank user_name
50 syn keyword sqlFunction user_id str stuff char_length nullif
51 syn keyword sqlFunction sortkey compare ts_index_statistics
52 syn keyword sqlFunction ts_table_statistics isdate isnumeric
53 syn keyword sqlFunction get_identity lookup newid uuidtostr
54 syn keyword sqlFunction strtouuid varexists
57 syn keyword sqlFunction acos asin atan atn2 cast ceiling convert cos cot
58 syn keyword sqlFunction char_length coalesce dateformat datetime degrees exp
59 syn keyword sqlFunction floor getdate insertstr
60 syn keyword sqlFunction log log10 lower mod pi power
61 syn keyword sqlFunction property radians replicate round sign sin
62 syn keyword sqlFunction sqldialect tan truncate truncnum
63 syn keyword sqlFunction base64_encode base64_decode
64 syn keyword sqlFunction hash compress decompress encrypt decrypt
67 syn keyword sqlFunction connection_extended_property text_handle_vector_match
68 syn keyword sqlFunction read_client_file write_client_file
71 syn keyword sqlFunction ascii char left ltrim repeat
72 syn keyword sqlFunction space right rtrim trim lcase ucase
73 syn keyword sqlFunction locate charindex patindex replace
74 syn keyword sqlFunction errormsg csconvert
77 syn keyword sqlFunction db_id db_name property_name
78 syn keyword sqlFunction property_description property_number
79 syn keyword sqlFunction next_connection next_database property
80 syn keyword sqlFunction connection_property db_property db_extended_property
81 syn keyword sqlFunction event_parmeter event_condition event_condition_name
84 syn keyword sqlFunction sa_add_index_consultant_analysis
85 syn keyword sqlFunction sa_add_workload_query
86 syn keyword sqlFunction sa_app_deregister
87 syn keyword sqlFunction sa_app_get_infoStr
88 syn keyword sqlFunction sa_app_get_status
89 syn keyword sqlFunction sa_app_register
90 syn keyword sqlFunction sa_app_registration_unlock
91 syn keyword sqlFunction sa_app_set_infoStr
92 syn keyword sqlFunction sa_audit_string
93 syn keyword sqlFunction sa_check_commit
94 syn keyword sqlFunction sa_checkpoint_execute
95 syn keyword sqlFunction sa_conn_activity
96 syn keyword sqlFunction sa_conn_compression_info
97 syn keyword sqlFunction sa_conn_deregister
98 syn keyword sqlFunction sa_conn_info
99 syn keyword sqlFunction sa_conn_properties
100 syn keyword sqlFunction sa_conn_properties_by_conn
101 syn keyword sqlFunction sa_conn_properties_by_name
102 syn keyword sqlFunction sa_conn_register
103 syn keyword sqlFunction sa_conn_set_status
104 syn keyword sqlFunction sa_create_analysis_from_query
105 syn keyword sqlFunction sa_db_info
106 syn keyword sqlFunction sa_db_properties
107 syn keyword sqlFunction sa_disable_auditing_type
108 syn keyword sqlFunction sa_disable_index
109 syn keyword sqlFunction sa_disk_free_space
110 syn keyword sqlFunction sa_enable_auditing_type
111 syn keyword sqlFunction sa_enable_index
112 syn keyword sqlFunction sa_end_forward_to
113 syn keyword sqlFunction sa_eng_properties
114 syn keyword sqlFunction sa_event_schedules
115 syn keyword sqlFunction sa_exec_script
116 syn keyword sqlFunction sa_flush_cache
117 syn keyword sqlFunction sa_flush_statistics
118 syn keyword sqlFunction sa_forward_to
119 syn keyword sqlFunction sa_get_dtt
120 syn keyword sqlFunction sa_get_histogram
121 syn keyword sqlFunction sa_get_request_profile
122 syn keyword sqlFunction sa_get_request_profile_sub
123 syn keyword sqlFunction sa_get_request_times
124 syn keyword sqlFunction sa_get_server_messages
125 syn keyword sqlFunction sa_get_simulated_scale_factors
126 syn keyword sqlFunction sa_get_workload_capture_status
127 syn keyword sqlFunction sa_index_density
128 syn keyword sqlFunction sa_index_levels
129 syn keyword sqlFunction sa_index_statistics
130 syn keyword sqlFunction sa_internal_alter_index_ability
131 syn keyword sqlFunction sa_internal_create_analysis_from_query
132 syn keyword sqlFunction sa_internal_disk_free_space
133 syn keyword sqlFunction sa_internal_get_dtt
134 syn keyword sqlFunction sa_internal_get_histogram
135 syn keyword sqlFunction sa_internal_get_request_times
136 syn keyword sqlFunction sa_internal_get_simulated_scale_factors
137 syn keyword sqlFunction sa_internal_get_workload_capture_status
138 syn keyword sqlFunction sa_internal_index_density
139 syn keyword sqlFunction sa_internal_index_levels
140 syn keyword sqlFunction sa_internal_index_statistics
141 syn keyword sqlFunction sa_internal_java_loaded_classes
142 syn keyword sqlFunction sa_internal_locks
143 syn keyword sqlFunction sa_internal_pause_workload_capture
144 syn keyword sqlFunction sa_internal_procedure_profile
145 syn keyword sqlFunction sa_internal_procedure_profile_summary
146 syn keyword sqlFunction sa_internal_read_backup_history
147 syn keyword sqlFunction sa_internal_recommend_indexes
148 syn keyword sqlFunction sa_internal_reset_identity
149 syn keyword sqlFunction sa_internal_resume_workload_capture
150 syn keyword sqlFunction sa_internal_start_workload_capture
151 syn keyword sqlFunction sa_internal_stop_index_consultant
152 syn keyword sqlFunction sa_internal_stop_workload_capture
153 syn keyword sqlFunction sa_internal_table_fragmentation
154 syn keyword sqlFunction sa_internal_table_page_usage
155 syn keyword sqlFunction sa_internal_table_stats
156 syn keyword sqlFunction sa_internal_virtual_sysindex
157 syn keyword sqlFunction sa_internal_virtual_sysixcol
158 syn keyword sqlFunction sa_java_loaded_classes
159 syn keyword sqlFunction sa_jdk_version
160 syn keyword sqlFunction sa_locks
161 syn keyword sqlFunction sa_make_object
162 syn keyword sqlFunction sa_pause_workload_capture
163 syn keyword sqlFunction sa_proc_debug_attach_to_connection
164 syn keyword sqlFunction sa_proc_debug_connect
165 syn keyword sqlFunction sa_proc_debug_detach_from_connection
166 syn keyword sqlFunction sa_proc_debug_disconnect
167 syn keyword sqlFunction sa_proc_debug_get_connection_name
168 syn keyword sqlFunction sa_proc_debug_release_connection
169 syn keyword sqlFunction sa_proc_debug_request
170 syn keyword sqlFunction sa_proc_debug_version
171 syn keyword sqlFunction sa_proc_debug_wait_for_connection
172 syn keyword sqlFunction sa_procedure_profile
173 syn keyword sqlFunction sa_procedure_profile_summary
174 syn keyword sqlFunction sa_read_backup_history
175 syn keyword sqlFunction sa_recommend_indexes
176 syn keyword sqlFunction sa_recompile_views
177 syn keyword sqlFunction sa_remove_index_consultant_analysis
178 syn keyword sqlFunction sa_remove_index_consultant_workload
179 syn keyword sqlFunction sa_reset_identity
180 syn keyword sqlFunction sa_resume_workload_capture
181 syn keyword sqlFunction sa_server_option
182 syn keyword sqlFunction sa_set_simulated_scale_factor
183 syn keyword sqlFunction sa_setremoteuser
184 syn keyword sqlFunction sa_setsubscription
185 syn keyword sqlFunction sa_start_recording_commits
186 syn keyword sqlFunction sa_start_workload_capture
187 syn keyword sqlFunction sa_statement_text
188 syn keyword sqlFunction sa_stop_index_consultant
189 syn keyword sqlFunction sa_stop_recording_commits
190 syn keyword sqlFunction sa_stop_workload_capture
191 syn keyword sqlFunction sa_sync
192 syn keyword sqlFunction sa_sync_sub
193 syn keyword sqlFunction sa_table_fragmentation
194 syn keyword sqlFunction sa_table_page_usage
195 syn keyword sqlFunction sa_table_stats
196 syn keyword sqlFunction sa_update_index_consultant_workload
197 syn keyword sqlFunction sa_validate
198 syn keyword sqlFunction sa_virtual_sysindex
199 syn keyword sqlFunction sa_virtual_sysixcol
202 syn keyword sqlFunction sp_addalias
203 syn keyword sqlFunction sp_addauditrecord
204 syn keyword sqlFunction sp_adddumpdevice
205 syn keyword sqlFunction sp_addgroup
206 syn keyword sqlFunction sp_addlanguage
207 syn keyword sqlFunction sp_addlogin
208 syn keyword sqlFunction sp_addmessage
209 syn keyword sqlFunction sp_addremotelogin
210 syn keyword sqlFunction sp_addsegment
211 syn keyword sqlFunction sp_addserver
212 syn keyword sqlFunction sp_addthreshold
213 syn keyword sqlFunction sp_addtype
214 syn keyword sqlFunction sp_adduser
215 syn keyword sqlFunction sp_auditdatabase
216 syn keyword sqlFunction sp_auditlogin
217 syn keyword sqlFunction sp_auditobject
218 syn keyword sqlFunction sp_auditoption
219 syn keyword sqlFunction sp_auditsproc
220 syn keyword sqlFunction sp_bindefault
221 syn keyword sqlFunction sp_bindmsg
222 syn keyword sqlFunction sp_bindrule
223 syn keyword sqlFunction sp_changedbowner
224 syn keyword sqlFunction sp_changegroup
225 syn keyword sqlFunction sp_checknames
226 syn keyword sqlFunction sp_checkperms
227 syn keyword sqlFunction sp_checkreswords
228 syn keyword sqlFunction sp_clearstats
229 syn keyword sqlFunction sp_column_privileges
230 syn keyword sqlFunction sp_columns
231 syn keyword sqlFunction sp_commonkey
232 syn keyword sqlFunction sp_configure
233 syn keyword sqlFunction sp_cursorinfo
234 syn keyword sqlFunction sp_databases
235 syn keyword sqlFunction sp_datatype_info
236 syn keyword sqlFunction sp_dboption
237 syn keyword sqlFunction sp_dbremap
238 syn keyword sqlFunction sp_depends
239 syn keyword sqlFunction sp_diskdefault
240 syn keyword sqlFunction sp_displaylogin
241 syn keyword sqlFunction sp_dropalias
242 syn keyword sqlFunction sp_dropdevice
243 syn keyword sqlFunction sp_dropgroup
244 syn keyword sqlFunction sp_dropkey
245 syn keyword sqlFunction sp_droplanguage
246 syn keyword sqlFunction sp_droplogin
247 syn keyword sqlFunction sp_dropmessage
248 syn keyword sqlFunction sp_dropremotelogin
249 syn keyword sqlFunction sp_dropsegment
250 syn keyword sqlFunction sp_dropserver
251 syn keyword sqlFunction sp_dropthreshold
252 syn keyword sqlFunction sp_droptype
253 syn keyword sqlFunction sp_dropuser
254 syn keyword sqlFunction sp_estspace
255 syn keyword sqlFunction sp_extendsegment
256 syn keyword sqlFunction sp_fkeys
257 syn keyword sqlFunction sp_foreignkey
258 syn keyword sqlFunction sp_getmessage
259 syn keyword sqlFunction sp_help
260 syn keyword sqlFunction sp_helpconstraint
261 syn keyword sqlFunction sp_helpdb
262 syn keyword sqlFunction sp_helpdevice
263 syn keyword sqlFunction sp_helpgroup
264 syn keyword sqlFunction sp_helpindex
265 syn keyword sqlFunction sp_helpjoins
266 syn keyword sqlFunction sp_helpkey
267 syn keyword sqlFunction sp_helplanguage
268 syn keyword sqlFunction sp_helplog
269 syn keyword sqlFunction sp_helpprotect
270 syn keyword sqlFunction sp_helpremotelogin
271 syn keyword sqlFunction sp_helpsegment
272 syn keyword sqlFunction sp_helpserver
273 syn keyword sqlFunction sp_helpsort
274 syn keyword sqlFunction sp_helptext
275 syn keyword sqlFunction sp_helpthreshold
276 syn keyword sqlFunction sp_helpuser
277 syn keyword sqlFunction sp_indsuspect
278 syn keyword sqlFunction sp_lock
279 syn keyword sqlFunction sp_locklogin
280 syn keyword sqlFunction sp_logdevice
281 syn keyword sqlFunction sp_login_environment
282 syn keyword sqlFunction sp_modifylogin
283 syn keyword sqlFunction sp_modifythreshold
284 syn keyword sqlFunction sp_monitor
285 syn keyword sqlFunction sp_password
286 syn keyword sqlFunction sp_pkeys
287 syn keyword sqlFunction sp_placeobject
288 syn keyword sqlFunction sp_primarykey
289 syn keyword sqlFunction sp_procxmode
290 syn keyword sqlFunction sp_recompile
291 syn keyword sqlFunction sp_remap
292 syn keyword sqlFunction sp_remote_columns
293 syn keyword sqlFunction sp_remote_exported_keys
294 syn keyword sqlFunction sp_remote_imported_keys
295 syn keyword sqlFunction sp_remote_pcols
296 syn keyword sqlFunction sp_remote_primary_keys
297 syn keyword sqlFunction sp_remote_procedures
298 syn keyword sqlFunction sp_remote_tables
299 syn keyword sqlFunction sp_remoteoption
300 syn keyword sqlFunction sp_rename
301 syn keyword sqlFunction sp_renamedb
302 syn keyword sqlFunction sp_reportstats
303 syn keyword sqlFunction sp_reset_tsql_environment
304 syn keyword sqlFunction sp_role
305 syn keyword sqlFunction sp_server_info
306 syn keyword sqlFunction sp_servercaps
307 syn keyword sqlFunction sp_serverinfo
308 syn keyword sqlFunction sp_serveroption
309 syn keyword sqlFunction sp_setlangalias
310 syn keyword sqlFunction sp_setreplicate
311 syn keyword sqlFunction sp_setrepproc
312 syn keyword sqlFunction sp_setreptable
313 syn keyword sqlFunction sp_spaceused
314 syn keyword sqlFunction sp_special_columns
315 syn keyword sqlFunction sp_sproc_columns
316 syn keyword sqlFunction sp_statistics
317 syn keyword sqlFunction sp_stored_procedures
318 syn keyword sqlFunction sp_syntax
319 syn keyword sqlFunction sp_table_privileges
320 syn keyword sqlFunction sp_tables
321 syn keyword sqlFunction sp_tsql_environment
322 syn keyword sqlFunction sp_tsql_feature_not_supported
323 syn keyword sqlFunction sp_unbindefault
324 syn keyword sqlFunction sp_unbindmsg
325 syn keyword sqlFunction sp_unbindrule
326 syn keyword sqlFunction sp_volchanged
327 syn keyword sqlFunction sp_who
328 syn keyword sqlFunction xp_scanf
329 syn keyword sqlFunction xp_sprintf
332 syn keyword sqlFunction col_length
333 syn keyword sqlFunction col_name
334 syn keyword sqlFunction index_col
335 syn keyword sqlFunction object_id
336 syn keyword sqlFunction object_name
337 syn keyword sqlFunction proc_role
338 syn keyword sqlFunction show_role
339 syn keyword sqlFunction xp_cmdshell
340 syn keyword sqlFunction xp_msver
341 syn keyword sqlFunction xp_read_file
342 syn keyword sqlFunction xp_real_cmdshell
343 syn keyword sqlFunction xp_real_read_file
344 syn keyword sqlFunction xp_real_sendmail
345 syn keyword sqlFunction xp_real_startmail
346 syn keyword sqlFunction xp_real_startsmtp
347 syn keyword sqlFunction xp_real_stopmail
348 syn keyword sqlFunction xp_real_stopsmtp
349 syn keyword sqlFunction xp_real_write_file
350 syn keyword sqlFunction xp_scanf
351 syn keyword sqlFunction xp_sendmail
352 syn keyword sqlFunction xp_sprintf
353 syn keyword sqlFunction xp_startmail
354 syn keyword sqlFunction xp_startsmtp
355 syn keyword sqlFunction xp_stopmail
356 syn keyword sqlFunction xp_stopsmtp
357 syn keyword sqlFunction xp_write_file
360 syn keyword sqlFunction http_header http_variable
361 syn keyword sqlFunction next_http_header next_http_variable
362 syn keyword sqlFunction sa_set_http_header sa_set_http_option
363 syn keyword sqlFunction sa_http_variable_info sa_http_header_info
365 " http functions 9.0.1
366 syn keyword sqlFunction http_encode http_decode
367 syn keyword sqlFunction html_encode html_decode
370 syn keyword sqlKeyword absolute accent action active add address aes_decrypt
371 syn keyword sqlKeyword after aggregate algorithm allow_dup_row allowed
372 syn keyword sqlKeyword alter and ansi_substring any as append apply asc ascii ase
373 syn keyword sqlKeyword assign at atan2 atomic attach attended audit authorization
374 syn keyword sqlKeyword autoincrement autostop batch bcp before
375 syn keyword sqlKeyword between bit_and bit_length bit_or bit_substr bit_xor
376 syn keyword sqlKeyword blank blanks block
377 syn keyword sqlKeyword both bottom unbounded break breaker bufferpool
378 syn keyword sqlKeyword build bulk by byte bytes cache calibrate calibration
379 syn keyword sqlKeyword cancel capability cascade cast
380 syn keyword sqlKeyword catalog ceil changes char char_convert check checksum
381 syn keyword sqlKeyword class classes client cmp
382 syn keyword sqlKeyword cluster clustered collation
383 syn keyword sqlKeyword column columns
384 syn keyword sqlKeyword command comment committed comparisons
385 syn keyword sqlKeyword compatible component compressed compute computes
386 syn keyword sqlKeyword concat configuration confirm conflict connection
387 syn keyword sqlKeyword console consolidate consolidated
388 syn keyword sqlKeyword constraint constraints content continue
389 syn keyword sqlKeyword convert coordinator copy count count_set_bits
390 syn keyword sqlKeyword crc createtime cross cube cume_dist
391 syn keyword sqlKeyword current cursor data data database
392 syn keyword sqlKeyword current_timestamp current_user
393 syn keyword sqlKeyword databases datatype dba dbfile
394 syn keyword sqlKeyword dbspace dbspaces dbspacename debug decoupled
395 syn keyword sqlKeyword decrypted default defaults default_dbspace deferred
396 syn keyword sqlKeyword definer definition
397 syn keyword sqlKeyword delay deleting delimited dependencies desc
398 syn keyword sqlKeyword description detach deterministic directory
399 syn keyword sqlKeyword disable disabled distinct do domain download duplicate
400 syn keyword sqlKeyword dsetpass dttm dynamic each editproc ejb
401 syn keyword sqlKeyword else elseif empty enable encapsulated encrypted end
402 syn keyword sqlKeyword encoding endif engine environment erase error escape escapes event
403 syn keyword sqlKeyword event_parameter every except exception exclude excluded exclusive exec
404 syn keyword sqlKeyword existing exists expanded expiry express exprtype extended_property
405 syn keyword sqlKeyword external externlogin factor failover false
406 syn keyword sqlKeyword fastfirstrow fieldproc file files filler
407 syn keyword sqlKeyword fillfactor finish first first_keyword first_value
408 syn keyword sqlKeyword following force foreign format forxml forxml_sep fp frame
409 syn keyword sqlKeyword freepage french fresh full function gb get_bit go global
410 syn keyword sqlKeyword group handler hash having header hexadecimal
411 syn keyword sqlKeyword hidden high history hg hng hold holdlock host
412 syn keyword sqlKeyword hours http_body http_session_timeout id identified identity ignore
413 syn keyword sqlKeyword ignore_dup_key ignore_dup_row immediate
414 syn keyword sqlKeyword in inactiv inactive inactivity included incremental
415 syn keyword sqlKeyword index index_enabled index_lparen indexonly info
416 syn keyword sqlKeyword inline inner inout insensitive inserting
417 syn keyword sqlKeyword instead integrated
418 syn keyword sqlKeyword internal intersection into introduced invoker iq is isolation
419 syn keyword sqlKeyword jar java java_location java_main_userid java_vm_options
420 syn keyword sqlKeyword jconnect jdk join kb key keep kerberos language last
421 syn keyword sqlKeyword last_keyword last_value lateral ld left len lf ln level like
422 syn keyword sqlKeyword limit local location log
423 syn keyword sqlKeyword logging login logscan long low lru main manual mark
424 syn keyword sqlKeyword match matched materialized max maximum mb membership
425 syn keyword sqlKeyword merge metadata methods minimum minutes mirror mode modify monitor move mru
426 syn keyword sqlKeyword multiplex name named national native natural new next no
427 syn keyword sqlKeyword noholdlock nolock nonclustered none not
428 syn keyword sqlKeyword notify null nullable_constant nulls object oem_string of off offline
429 syn keyword sqlKeyword old on online only openstring optimization optimizer option
430 syn keyword sqlKeyword or order others out outer over
431 syn keyword sqlKeyword package packetsize padding page pages
432 syn keyword sqlKeyword paglock parallel part partial partition partitions partner password path
433 syn keyword sqlKeyword pctfree plan policy populate port postfilter preceding precision
434 syn keyword sqlKeyword prefetch prefilter prefix preserve preview primary
435 syn keyword sqlKeyword prior priority priqty private privileges procedure profile
436 syn keyword sqlKeyword property_is_cumulative property_is_numeric public publication publish publisher
437 syn keyword sqlKeyword quiesce quote quotes range readclientfile readcommitted reader readfile readonly
438 syn keyword sqlKeyword readpast readuncommitted readwrite rebuild
439 syn keyword sqlKeyword received recompile recover recursive references
440 syn keyword sqlKeyword referencing refresh regex regexp regexp_substr relative relocate
441 syn keyword sqlKeyword rename repeatable repeatableread
442 syn keyword sqlKeyword replicate request_timeout required rereceive resend reserve reset
443 syn keyword sqlKeyword resizing resolve resource respect
444 syn keyword sqlKeyword restrict result retain
445 syn keyword sqlKeyword returns reverse right role
446 syn keyword sqlKeyword rollup root row row_number rowlock rows save
447 syn keyword sqlKeyword sa_index_hash sa_internal_fk_verify sa_internal_termbreak
448 syn keyword sqlKeyword sa_order_preserving_hash sa_order_preserving_hash_big sa_order_preserving_hash_prefix
449 syn keyword sqlKeyword schedule schema scope scripted scroll seconds secqty security
450 syn keyword sqlKeyword send sensitive sent serializable
451 syn keyword sqlKeyword server server session set_bit set_bits sets
452 syn keyword sqlKeyword share simple since site size skip
453 syn keyword sqlKeyword snapshot soapheader soap_header split some sorted_data
454 syn keyword sqlKeyword sqlcode sqlid sqlflagger sqlstate sqrt square
455 syn keyword sqlKeyword stacker stale statement statistics status stddev_pop stddev_samp
456 syn keyword sqlKeyword stemmer stogroup stoplist store
457 syn keyword sqlKeyword strip stripesizekb striping subpages subscribe subscription
458 syn keyword sqlKeyword subtransaction suser_id suser_name synchronization
459 syn keyword sqlKeyword syntax_error table tablock
460 syn keyword sqlKeyword tablockx tb temp template temporary term then
461 syn keyword sqlKeyword ties timezone to to_char to_nchar top traced_plan tracing
462 syn keyword sqlKeyword transfer transaction transactional tries true
463 syn keyword sqlKeyword tsequal type tune uncommitted unconditionally
464 syn keyword sqlKeyword unenforced unicode unique union unistr unknown unlimited unload
465 syn keyword sqlKeyword unpartition unquiesce updatetime updating updlock upgrade upload
466 syn keyword sqlKeyword upper use user
467 syn keyword sqlKeyword using utc utilities validproc
468 syn keyword sqlKeyword value values varchar variable
469 syn keyword sqlKeyword varying var_pop var_samp vcat verify versions view virtual wait
470 syn keyword sqlKeyword warning wd web when where window with with_auto
471 syn keyword sqlKeyword with_auto with_cube with_rollup without
472 syn keyword sqlKeyword with_lparen within word work workload write writefile
473 syn keyword sqlKeyword writeclientfile writer writers writeserver xlock zeros
474 " XML function support
475 syn keyword sqlFunction openxml xmlelement xmlforest xmlgen xmlconcat xmlagg
476 syn keyword sqlFunction xmlattributes
477 syn keyword sqlKeyword raw auto elements explicit
479 syn keyword sqlKeyword authorization secure url service next_soap_header
480 " HTTP 9.0.2 new procedure keywords
481 syn keyword sqlKeyword namespace certificate clientport proxy
483 syn keyword sqlKeyword covar_pop covar_samp corr regr_slope regr_intercept
484 syn keyword sqlKeyword regr_count regr_r2 regr_avgx regr_avgy
485 syn keyword sqlKeyword regr_sxx regr_syy regr_sxy
488 syn keyword sqlKeyword character dec options proc reference
489 syn keyword sqlKeyword subtrans tran syn keyword
492 syn keyword sqlOperator in any some all between exists
493 syn keyword sqlOperator like escape not is and or
494 syn keyword sqlOperator intersect minus
495 syn keyword sqlOperator prior distinct
497 syn keyword sqlStatement allocate alter backup begin call case
498 syn keyword sqlStatement checkpoint clear close commit configure connect
499 syn keyword sqlStatement create deallocate declare delete describe
500 syn keyword sqlStatement disconnect drop execute exit explain fetch
501 syn keyword sqlStatement for forward from get goto grant help if include
502 syn keyword sqlStatement input insert install leave load lock loop
503 syn keyword sqlStatement message open output parameter parameters passthrough
504 syn keyword sqlStatement prepare print put raiserror read readtext release
505 syn keyword sqlStatement remote remove reorganize resignal restore resume
506 syn keyword sqlStatement return revoke rollback savepoint select
507 syn keyword sqlStatement set setuser signal start stop synchronize
508 syn keyword sqlStatement system trigger truncate unload update
509 syn keyword sqlStatement validate waitfor whenever while writetext
512 syn keyword sqlType char long varchar text
513 syn keyword sqlType bigint decimal double float int integer numeric
514 syn keyword sqlType smallint tinyint real
515 syn keyword sqlType money smallmoney
516 syn keyword sqlType bit
517 syn keyword sqlType date datetime smalldate time timestamp
518 syn keyword sqlType binary image varbinary uniqueidentifier
519 syn keyword sqlType xml unsigned
521 syn keyword sqlType varbit nchar nvarchar
523 syn keyword sqlOption Allow_nulls_by_default
524 syn keyword sqlOption Allow_read_client_file
525 syn keyword sqlOption Allow_snapshot_isolation
526 syn keyword sqlOption Allow_write_client_file
527 syn keyword sqlOption Ansi_blanks
528 syn keyword sqlOption Ansi_close_cursors_on_rollback
529 syn keyword sqlOption Ansi_permissions
530 syn keyword sqlOption Ansi_substring
531 syn keyword sqlOption Ansi_update_constraints
532 syn keyword sqlOption Ansinull
533 syn keyword sqlOption Auditing
534 syn keyword sqlOption Auditing_options
535 syn keyword sqlOption Background_priority
536 syn keyword sqlOption Blocking
537 syn keyword sqlOption Blocking_timeout
538 syn keyword sqlOption Chained
539 syn keyword sqlOption Checkpoint_time
540 syn keyword sqlOption Cis_option
541 syn keyword sqlOption Cis_rowset_size
542 syn keyword sqlOption Close_on_endtrans
543 syn keyword sqlOption Collect_statistics_on_dml_updates
544 syn keyword sqlOption Conn_auditing
545 syn keyword sqlOption Connection_authentication
546 syn keyword sqlOption Continue_after_raiserror
547 syn keyword sqlOption Conversion_error
548 syn keyword sqlOption Cooperative_commit_timeout
549 syn keyword sqlOption Cooperative_commits
550 syn keyword sqlOption Database_authentication
551 syn keyword sqlOption Date_format
552 syn keyword sqlOption Date_order
553 syn keyword sqlOption Debug_messages
554 syn keyword sqlOption Dedicated_task
555 syn keyword sqlOption Default_dbspace
556 syn keyword sqlOption Default_timestamp_increment
557 syn keyword sqlOption Delayed_commit_timeout
558 syn keyword sqlOption Delayed_commits
559 syn keyword sqlOption Escape_character
560 syn keyword sqlOption Exclude_operators
561 syn keyword sqlOption Extended_join_syntax
562 syn keyword sqlOption Fire_triggers
563 syn keyword sqlOption First_day_of_week
564 syn keyword sqlOption For_xml_null_treatment
565 syn keyword sqlOption Force_view_creation
566 syn keyword sqlOption Global_database_id
567 syn keyword sqlOption Http_session_timeout
568 syn keyword sqlOption Integrated_server_name
569 syn keyword sqlOption Isolation_level
570 syn keyword sqlOption Java_location
571 syn keyword sqlOption Java_main_userid
572 syn keyword sqlOption Java_vm_options
573 syn keyword sqlOption Lock_rejected_rows
574 syn keyword sqlOption Log_deadlocks
575 syn keyword sqlOption Login_mode
576 syn keyword sqlOption Login_procedure
577 syn keyword sqlOption Materialized_view_optimization
578 syn keyword sqlOption Max_client_statements_cached
579 syn keyword sqlOption Max_cursor_count
580 syn keyword sqlOption Max_hash_size
581 syn keyword sqlOption Max_plans_cached
582 syn keyword sqlOption Max_priority
583 syn keyword sqlOption Max_query_tasks
584 syn keyword sqlOption Max_recursive_iterations
585 syn keyword sqlOption Max_statement_count
586 syn keyword sqlOption Max_temp_space
587 syn keyword sqlOption Min_password_length
588 syn keyword sqlOption Nearest_century
589 syn keyword sqlOption Non_keywords
590 syn keyword sqlOption Odbc_describe_binary_as_varbinary
591 syn keyword sqlOption Odbc_distinguish_char_and_varchar
592 syn keyword sqlOption Oem_string
593 syn keyword sqlOption On_charset_conversion_failure
594 syn keyword sqlOption On_tsql_error
595 syn keyword sqlOption Optimization_goal
596 syn keyword sqlOption Optimization_level
597 syn keyword sqlOption Optimization_workload
598 syn keyword sqlOption Pinned_cursor_percent_of_cache
599 syn keyword sqlOption Post_login_procedure
600 syn keyword sqlOption Precision
601 syn keyword sqlOption Prefetch
602 syn keyword sqlOption Preserve_source_format
603 syn keyword sqlOption Prevent_article_pkey_update
604 syn keyword sqlOption Priority
605 syn keyword sqlOption Query_mem_timeout
606 syn keyword sqlOption Quoted_identifier
607 syn keyword sqlOption Read_past_deleted
608 syn keyword sqlOption Recovery_time
609 syn keyword sqlOption Remote_idle_timeout
610 syn keyword sqlOption Replicate_all
611 syn keyword sqlOption Request_timeout
612 syn keyword sqlOption Return_date_time_as_string
613 syn keyword sqlOption Rollback_on_deadlock
614 syn keyword sqlOption Row_counts
615 syn keyword sqlOption Scale
616 syn keyword sqlOption Secure_feature_key
617 syn keyword sqlOption Sort_collation
618 syn keyword sqlOption Sql_flagger_error_level
619 syn keyword sqlOption Sql_flagger_warning_level
620 syn keyword sqlOption String_rtruncation
621 syn keyword sqlOption Subsume_row_locks
622 syn keyword sqlOption Suppress_tds_debugging
623 syn keyword sqlOption Synchronize_mirror_on_commit
624 syn keyword sqlOption Tds_empty_string_is_null
625 syn keyword sqlOption Temp_space_limit_check
626 syn keyword sqlOption Time_format
627 syn keyword sqlOption Time_zone_adjustment
628 syn keyword sqlOption Timestamp_format
629 syn keyword sqlOption Truncate_timestamp_values
630 syn keyword sqlOption Tsql_outer_joins
631 syn keyword sqlOption Tsql_variables
632 syn keyword sqlOption Updatable_statement_isolation
633 syn keyword sqlOption Update_statistics
634 syn keyword sqlOption Upgrade_database_capability
635 syn keyword sqlOption User_estimates
636 syn keyword sqlOption Verify_password_function
637 syn keyword sqlOption Wait_for_commit
638 syn keyword sqlOption Webservice_namespace_host
640 " Strings and characters:
641 syn region sqlString start=+"+ end=+"+ contains=@Spell
642 syn region sqlString start=+'+ end=+'+ contains=@Spell
645 syn match sqlNumber "-\=\<\d*\.\=[0-9_]\>"
648 syn region sqlDashComment start=/--/ end=/$/ contains=@Spell
649 syn region sqlSlashComment start=/\/\// end=/$/ contains=@Spell
650 syn region sqlMultiComment start="/\*" end="\*/" contains=sqlMultiComment,@Spell
651 syn cluster sqlComment contains=sqlDashComment,sqlSlashComment,sqlMultiComment,@Spell
652 syn sync ccomment sqlComment
653 syn sync ccomment sqlDashComment
654 syn sync ccomment sqlSlashComment
656 " Define the default highlighting.
657 " For version 5.7 and earlier: only when not done already
658 " For version 5.8 and later: only when an item doesn't have highlighting yet
659 if version >= 508 || !exists("did_sql_syn_inits")
661 let did_sql_syn_inits = 1
662 command -nargs=+ HiLink hi link <args>
664 command -nargs=+ HiLink hi link <args>
667 HiLink sqlDashComment Comment
668 HiLink sqlSlashComment Comment
669 HiLink sqlMultiComment Comment
670 HiLink sqlNumber Number
671 HiLink sqlOperator Operator
672 HiLink sqlSpecial Special
673 HiLink sqlKeyword Keyword
674 HiLink sqlStatement Statement
675 HiLink sqlString String
677 HiLink sqlFunction Function
678 HiLink sqlOption PreProc
683 let b:current_syntax = "sqlanywhere"