3 " Language: SQL, Adaptive Server Anywhere
4 " Maintainer: David Fishburn <fishburn at ianywhere dot com>
5 " Last Change: Tue 29 Jan 2008 12:54:19 PM Eastern Standard Time
8 " Description: 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 ascii char left ltrim repeat
68 syn keyword sqlFunction space right rtrim trim lcase ucase
69 syn keyword sqlFunction locate charindex patindex replace
70 syn keyword sqlFunction errormsg csconvert
73 syn keyword sqlFunction db_id db_name property_name
74 syn keyword sqlFunction property_description property_number
75 syn keyword sqlFunction next_connection next_database property
76 syn keyword sqlFunction connection_property db_property db_extended_property
77 syn keyword sqlFunction event_parmeter event_condition event_condition_name
80 syn keyword sqlFunction sa_add_index_consultant_analysis
81 syn keyword sqlFunction sa_add_workload_query
82 syn keyword sqlFunction sa_app_deregister
83 syn keyword sqlFunction sa_app_get_infoStr
84 syn keyword sqlFunction sa_app_get_status
85 syn keyword sqlFunction sa_app_register
86 syn keyword sqlFunction sa_app_registration_unlock
87 syn keyword sqlFunction sa_app_set_infoStr
88 syn keyword sqlFunction sa_audit_string
89 syn keyword sqlFunction sa_check_commit
90 syn keyword sqlFunction sa_checkpoint_execute
91 syn keyword sqlFunction sa_conn_activity
92 syn keyword sqlFunction sa_conn_compression_info
93 syn keyword sqlFunction sa_conn_deregister
94 syn keyword sqlFunction sa_conn_info
95 syn keyword sqlFunction sa_conn_properties
96 syn keyword sqlFunction sa_conn_properties_by_conn
97 syn keyword sqlFunction sa_conn_properties_by_name
98 syn keyword sqlFunction sa_conn_register
99 syn keyword sqlFunction sa_conn_set_status
100 syn keyword sqlFunction sa_create_analysis_from_query
101 syn keyword sqlFunction sa_db_info
102 syn keyword sqlFunction sa_db_properties
103 syn keyword sqlFunction sa_disable_auditing_type
104 syn keyword sqlFunction sa_disable_index
105 syn keyword sqlFunction sa_disk_free_space
106 syn keyword sqlFunction sa_enable_auditing_type
107 syn keyword sqlFunction sa_enable_index
108 syn keyword sqlFunction sa_end_forward_to
109 syn keyword sqlFunction sa_eng_properties
110 syn keyword sqlFunction sa_event_schedules
111 syn keyword sqlFunction sa_exec_script
112 syn keyword sqlFunction sa_flush_cache
113 syn keyword sqlFunction sa_flush_statistics
114 syn keyword sqlFunction sa_forward_to
115 syn keyword sqlFunction sa_get_dtt
116 syn keyword sqlFunction sa_get_histogram
117 syn keyword sqlFunction sa_get_request_profile
118 syn keyword sqlFunction sa_get_request_profile_sub
119 syn keyword sqlFunction sa_get_request_times
120 syn keyword sqlFunction sa_get_server_messages
121 syn keyword sqlFunction sa_get_simulated_scale_factors
122 syn keyword sqlFunction sa_get_workload_capture_status
123 syn keyword sqlFunction sa_index_density
124 syn keyword sqlFunction sa_index_levels
125 syn keyword sqlFunction sa_index_statistics
126 syn keyword sqlFunction sa_internal_alter_index_ability
127 syn keyword sqlFunction sa_internal_create_analysis_from_query
128 syn keyword sqlFunction sa_internal_disk_free_space
129 syn keyword sqlFunction sa_internal_get_dtt
130 syn keyword sqlFunction sa_internal_get_histogram
131 syn keyword sqlFunction sa_internal_get_request_times
132 syn keyword sqlFunction sa_internal_get_simulated_scale_factors
133 syn keyword sqlFunction sa_internal_get_workload_capture_status
134 syn keyword sqlFunction sa_internal_index_density
135 syn keyword sqlFunction sa_internal_index_levels
136 syn keyword sqlFunction sa_internal_index_statistics
137 syn keyword sqlFunction sa_internal_java_loaded_classes
138 syn keyword sqlFunction sa_internal_locks
139 syn keyword sqlFunction sa_internal_pause_workload_capture
140 syn keyword sqlFunction sa_internal_procedure_profile
141 syn keyword sqlFunction sa_internal_procedure_profile_summary
142 syn keyword sqlFunction sa_internal_read_backup_history
143 syn keyword sqlFunction sa_internal_recommend_indexes
144 syn keyword sqlFunction sa_internal_reset_identity
145 syn keyword sqlFunction sa_internal_resume_workload_capture
146 syn keyword sqlFunction sa_internal_start_workload_capture
147 syn keyword sqlFunction sa_internal_stop_index_consultant
148 syn keyword sqlFunction sa_internal_stop_workload_capture
149 syn keyword sqlFunction sa_internal_table_fragmentation
150 syn keyword sqlFunction sa_internal_table_page_usage
151 syn keyword sqlFunction sa_internal_table_stats
152 syn keyword sqlFunction sa_internal_virtual_sysindex
153 syn keyword sqlFunction sa_internal_virtual_sysixcol
154 syn keyword sqlFunction sa_java_loaded_classes
155 syn keyword sqlFunction sa_jdk_version
156 syn keyword sqlFunction sa_locks
157 syn keyword sqlFunction sa_make_object
158 syn keyword sqlFunction sa_pause_workload_capture
159 syn keyword sqlFunction sa_proc_debug_attach_to_connection
160 syn keyword sqlFunction sa_proc_debug_connect
161 syn keyword sqlFunction sa_proc_debug_detach_from_connection
162 syn keyword sqlFunction sa_proc_debug_disconnect
163 syn keyword sqlFunction sa_proc_debug_get_connection_name
164 syn keyword sqlFunction sa_proc_debug_release_connection
165 syn keyword sqlFunction sa_proc_debug_request
166 syn keyword sqlFunction sa_proc_debug_version
167 syn keyword sqlFunction sa_proc_debug_wait_for_connection
168 syn keyword sqlFunction sa_procedure_profile
169 syn keyword sqlFunction sa_procedure_profile_summary
170 syn keyword sqlFunction sa_read_backup_history
171 syn keyword sqlFunction sa_recommend_indexes
172 syn keyword sqlFunction sa_recompile_views
173 syn keyword sqlFunction sa_remove_index_consultant_analysis
174 syn keyword sqlFunction sa_remove_index_consultant_workload
175 syn keyword sqlFunction sa_reset_identity
176 syn keyword sqlFunction sa_resume_workload_capture
177 syn keyword sqlFunction sa_server_option
178 syn keyword sqlFunction sa_set_simulated_scale_factor
179 syn keyword sqlFunction sa_setremoteuser
180 syn keyword sqlFunction sa_setsubscription
181 syn keyword sqlFunction sa_start_recording_commits
182 syn keyword sqlFunction sa_start_workload_capture
183 syn keyword sqlFunction sa_statement_text
184 syn keyword sqlFunction sa_stop_index_consultant
185 syn keyword sqlFunction sa_stop_recording_commits
186 syn keyword sqlFunction sa_stop_workload_capture
187 syn keyword sqlFunction sa_sync
188 syn keyword sqlFunction sa_sync_sub
189 syn keyword sqlFunction sa_table_fragmentation
190 syn keyword sqlFunction sa_table_page_usage
191 syn keyword sqlFunction sa_table_stats
192 syn keyword sqlFunction sa_update_index_consultant_workload
193 syn keyword sqlFunction sa_validate
194 syn keyword sqlFunction sa_virtual_sysindex
195 syn keyword sqlFunction sa_virtual_sysixcol
198 syn keyword sqlFunction sp_addalias
199 syn keyword sqlFunction sp_addauditrecord
200 syn keyword sqlFunction sp_adddumpdevice
201 syn keyword sqlFunction sp_addgroup
202 syn keyword sqlFunction sp_addlanguage
203 syn keyword sqlFunction sp_addlogin
204 syn keyword sqlFunction sp_addmessage
205 syn keyword sqlFunction sp_addremotelogin
206 syn keyword sqlFunction sp_addsegment
207 syn keyword sqlFunction sp_addserver
208 syn keyword sqlFunction sp_addthreshold
209 syn keyword sqlFunction sp_addtype
210 syn keyword sqlFunction sp_adduser
211 syn keyword sqlFunction sp_auditdatabase
212 syn keyword sqlFunction sp_auditlogin
213 syn keyword sqlFunction sp_auditobject
214 syn keyword sqlFunction sp_auditoption
215 syn keyword sqlFunction sp_auditsproc
216 syn keyword sqlFunction sp_bindefault
217 syn keyword sqlFunction sp_bindmsg
218 syn keyword sqlFunction sp_bindrule
219 syn keyword sqlFunction sp_changedbowner
220 syn keyword sqlFunction sp_changegroup
221 syn keyword sqlFunction sp_checknames
222 syn keyword sqlFunction sp_checkperms
223 syn keyword sqlFunction sp_checkreswords
224 syn keyword sqlFunction sp_clearstats
225 syn keyword sqlFunction sp_column_privileges
226 syn keyword sqlFunction sp_columns
227 syn keyword sqlFunction sp_commonkey
228 syn keyword sqlFunction sp_configure
229 syn keyword sqlFunction sp_cursorinfo
230 syn keyword sqlFunction sp_databases
231 syn keyword sqlFunction sp_datatype_info
232 syn keyword sqlFunction sp_dboption
233 syn keyword sqlFunction sp_dbremap
234 syn keyword sqlFunction sp_depends
235 syn keyword sqlFunction sp_diskdefault
236 syn keyword sqlFunction sp_displaylogin
237 syn keyword sqlFunction sp_dropalias
238 syn keyword sqlFunction sp_dropdevice
239 syn keyword sqlFunction sp_dropgroup
240 syn keyword sqlFunction sp_dropkey
241 syn keyword sqlFunction sp_droplanguage
242 syn keyword sqlFunction sp_droplogin
243 syn keyword sqlFunction sp_dropmessage
244 syn keyword sqlFunction sp_dropremotelogin
245 syn keyword sqlFunction sp_dropsegment
246 syn keyword sqlFunction sp_dropserver
247 syn keyword sqlFunction sp_dropthreshold
248 syn keyword sqlFunction sp_droptype
249 syn keyword sqlFunction sp_dropuser
250 syn keyword sqlFunction sp_estspace
251 syn keyword sqlFunction sp_extendsegment
252 syn keyword sqlFunction sp_fkeys
253 syn keyword sqlFunction sp_foreignkey
254 syn keyword sqlFunction sp_getmessage
255 syn keyword sqlFunction sp_help
256 syn keyword sqlFunction sp_helpconstraint
257 syn keyword sqlFunction sp_helpdb
258 syn keyword sqlFunction sp_helpdevice
259 syn keyword sqlFunction sp_helpgroup
260 syn keyword sqlFunction sp_helpindex
261 syn keyword sqlFunction sp_helpjoins
262 syn keyword sqlFunction sp_helpkey
263 syn keyword sqlFunction sp_helplanguage
264 syn keyword sqlFunction sp_helplog
265 syn keyword sqlFunction sp_helpprotect
266 syn keyword sqlFunction sp_helpremotelogin
267 syn keyword sqlFunction sp_helpsegment
268 syn keyword sqlFunction sp_helpserver
269 syn keyword sqlFunction sp_helpsort
270 syn keyword sqlFunction sp_helptext
271 syn keyword sqlFunction sp_helpthreshold
272 syn keyword sqlFunction sp_helpuser
273 syn keyword sqlFunction sp_indsuspect
274 syn keyword sqlFunction sp_lock
275 syn keyword sqlFunction sp_locklogin
276 syn keyword sqlFunction sp_logdevice
277 syn keyword sqlFunction sp_login_environment
278 syn keyword sqlFunction sp_modifylogin
279 syn keyword sqlFunction sp_modifythreshold
280 syn keyword sqlFunction sp_monitor
281 syn keyword sqlFunction sp_password
282 syn keyword sqlFunction sp_pkeys
283 syn keyword sqlFunction sp_placeobject
284 syn keyword sqlFunction sp_primarykey
285 syn keyword sqlFunction sp_procxmode
286 syn keyword sqlFunction sp_recompile
287 syn keyword sqlFunction sp_remap
288 syn keyword sqlFunction sp_remote_columns
289 syn keyword sqlFunction sp_remote_exported_keys
290 syn keyword sqlFunction sp_remote_imported_keys
291 syn keyword sqlFunction sp_remote_pcols
292 syn keyword sqlFunction sp_remote_primary_keys
293 syn keyword sqlFunction sp_remote_procedures
294 syn keyword sqlFunction sp_remote_tables
295 syn keyword sqlFunction sp_remoteoption
296 syn keyword sqlFunction sp_rename
297 syn keyword sqlFunction sp_renamedb
298 syn keyword sqlFunction sp_reportstats
299 syn keyword sqlFunction sp_reset_tsql_environment
300 syn keyword sqlFunction sp_role
301 syn keyword sqlFunction sp_server_info
302 syn keyword sqlFunction sp_servercaps
303 syn keyword sqlFunction sp_serverinfo
304 syn keyword sqlFunction sp_serveroption
305 syn keyword sqlFunction sp_setlangalias
306 syn keyword sqlFunction sp_setreplicate
307 syn keyword sqlFunction sp_setrepproc
308 syn keyword sqlFunction sp_setreptable
309 syn keyword sqlFunction sp_spaceused
310 syn keyword sqlFunction sp_special_columns
311 syn keyword sqlFunction sp_sproc_columns
312 syn keyword sqlFunction sp_statistics
313 syn keyword sqlFunction sp_stored_procedures
314 syn keyword sqlFunction sp_syntax
315 syn keyword sqlFunction sp_table_privileges
316 syn keyword sqlFunction sp_tables
317 syn keyword sqlFunction sp_tsql_environment
318 syn keyword sqlFunction sp_tsql_feature_not_supported
319 syn keyword sqlFunction sp_unbindefault
320 syn keyword sqlFunction sp_unbindmsg
321 syn keyword sqlFunction sp_unbindrule
322 syn keyword sqlFunction sp_volchanged
323 syn keyword sqlFunction sp_who
324 syn keyword sqlFunction xp_scanf
325 syn keyword sqlFunction xp_sprintf
328 syn keyword sqlFunction col_length
329 syn keyword sqlFunction col_name
330 syn keyword sqlFunction index_col
331 syn keyword sqlFunction object_id
332 syn keyword sqlFunction object_name
333 syn keyword sqlFunction proc_role
334 syn keyword sqlFunction show_role
335 syn keyword sqlFunction xp_cmdshell
336 syn keyword sqlFunction xp_msver
337 syn keyword sqlFunction xp_read_file
338 syn keyword sqlFunction xp_real_cmdshell
339 syn keyword sqlFunction xp_real_read_file
340 syn keyword sqlFunction xp_real_sendmail
341 syn keyword sqlFunction xp_real_startmail
342 syn keyword sqlFunction xp_real_startsmtp
343 syn keyword sqlFunction xp_real_stopmail
344 syn keyword sqlFunction xp_real_stopsmtp
345 syn keyword sqlFunction xp_real_write_file
346 syn keyword sqlFunction xp_scanf
347 syn keyword sqlFunction xp_sendmail
348 syn keyword sqlFunction xp_sprintf
349 syn keyword sqlFunction xp_startmail
350 syn keyword sqlFunction xp_startsmtp
351 syn keyword sqlFunction xp_stopmail
352 syn keyword sqlFunction xp_stopsmtp
353 syn keyword sqlFunction xp_write_file
356 syn keyword sqlFunction http_header http_variable
357 syn keyword sqlFunction next_http_header next_http_variable
358 syn keyword sqlFunction sa_set_http_header sa_set_http_option
359 syn keyword sqlFunction sa_http_variable_info sa_http_header_info
361 " http functions 9.0.1
362 syn keyword sqlFunction http_encode http_decode
363 syn keyword sqlFunction html_encode html_decode
366 syn keyword sqlKeyword absolute accent action activ add address after
367 syn keyword sqlKeyword algorithm allow_dup_row
368 syn keyword sqlKeyword alter and any as append asc ascii ase at atomic
369 syn keyword sqlKeyword attach attended audit authorization
370 syn keyword sqlKeyword autoincrement autostop batch bcp before
371 syn keyword sqlKeyword between blank blanks block
372 syn keyword sqlKeyword both bottom unbounded break bufferpool
373 syn keyword sqlKeyword build bulk by byte bytes cache calibrate calibration
374 syn keyword sqlKeyword cancel capability cascade cast
375 syn keyword sqlKeyword catalog changes char char_convert check checksum
376 syn keyword sqlKeyword class classes client cmp
377 syn keyword sqlKeyword cluster clustered collation column columns
378 syn keyword sqlKeyword command comment committed comparisons
379 syn keyword sqlKeyword compatible component compressed compute computes
380 syn keyword sqlKeyword concat confirm conflict connection
381 syn keyword sqlKeyword console consolidate consolidated
382 syn keyword sqlKeyword constraint constraints continue
383 syn keyword sqlKeyword convert copy count crc cross cube
384 syn keyword sqlKeyword current cursor data data database
385 syn keyword sqlKeyword current_timestamp current_user
386 syn keyword sqlKeyword datatype dba dbfile
387 syn keyword sqlKeyword dbspace dbspacename debug decoupled
388 syn keyword sqlKeyword decrypted default defaults deferred definition
389 syn keyword sqlKeyword delay deleting delimited dependencies desc
390 syn keyword sqlKeyword description detach deterministic directory
391 syn keyword sqlKeyword disable disabled distinct do domain download
392 syn keyword sqlKeyword dsetpass dttm dynamic each editproc ejb
393 syn keyword sqlKeyword else elseif enable encapsulated encrypted end
394 syn keyword sqlKeyword encoding endif engine erase error escape escapes event
395 syn keyword sqlKeyword every except exception exclude exclusive exec
396 syn keyword sqlKeyword existing exists expanded express
397 syn keyword sqlKeyword external externlogin factor failover false
398 syn keyword sqlKeyword fastfirstrow fieldproc file filler
399 syn keyword sqlKeyword fillfactor finish first first_keyword
400 syn keyword sqlKeyword following force foreign format
401 syn keyword sqlKeyword freepage french fresh full function go global
402 syn keyword sqlKeyword group handler hash having header hexadecimal
403 syn keyword sqlKeyword hidden high history hold holdlock
404 syn keyword sqlKeyword hours id identified identity ignore
405 syn keyword sqlKeyword ignore_dup_key ignore_dup_row immediate
406 syn keyword sqlKeyword in inactive inactivity incremental index info
407 syn keyword sqlKeyword inline inner inout insensitive inserting
408 syn keyword sqlKeyword instead integrated
409 syn keyword sqlKeyword internal into introduced iq is isolation jar java
410 syn keyword sqlKeyword jconnect jdk join kb key keep kerberos language last
411 syn keyword sqlKeyword last_keyword lateral left level like
412 syn keyword sqlKeyword limit local location log
413 syn keyword sqlKeyword logging login logscan long low lru main
414 syn keyword sqlKeyword match materialized max maximum membership
415 syn keyword sqlKeyword minutes mirror mode modify monitor mru
416 syn keyword sqlKeyword name named national native natural new next no
417 syn keyword sqlKeyword noholdlock nolock nonclustered none not
418 syn keyword sqlKeyword notify null nulls of off old on
419 syn keyword sqlKeyword only optimization optimizer option
420 syn keyword sqlKeyword or order others out outer over
421 syn keyword sqlKeyword package packetsize padding page pages
422 syn keyword sqlKeyword paglock parallel part partition partner password path
423 syn keyword sqlKeyword pctfree plan preceding precision prefetch prefix
424 syn keyword sqlKeyword preserve preview primary
425 syn keyword sqlKeyword prior priqty private privileges procedure profile
426 syn keyword sqlKeyword public publication publish publisher
427 syn keyword sqlKeyword quote quotes range readcommitted readonly
428 syn keyword sqlKeyword readpast readuncommitted readwrite rebuild
429 syn keyword sqlKeyword received recompile recover recursive references
430 syn keyword sqlKeyword referencing refresh relative relocate
431 syn keyword sqlKeyword rename repeatable repeatableread
432 syn keyword sqlKeyword replicate rereceive resend reserve reset
433 syn keyword sqlKeyword resizing resolve resource respect
434 syn keyword sqlKeyword restrict result retain
435 syn keyword sqlKeyword returns right
436 syn keyword sqlKeyword rollup root row rowlock rows save
437 syn keyword sqlKeyword schedule schema scripted scroll seconds secqty
438 syn keyword sqlKeyword send sensitive sent serializable
439 syn keyword sqlKeyword server server session sets
440 syn keyword sqlKeyword share simple since site size skip
441 syn keyword sqlKeyword snapshot soapheader some sorted_data
442 syn keyword sqlKeyword sqlcode sqlid sqlstate stacker stale statement
443 syn keyword sqlKeyword statistics status stogroup store
444 syn keyword sqlKeyword strip subpages subscribe subscription
445 syn keyword sqlKeyword subtransaction synchronization
446 syn keyword sqlKeyword syntax_error table tablock
447 syn keyword sqlKeyword tablockx tb temp template temporary then
448 syn keyword sqlKeyword ties timezone to top tracing
449 syn keyword sqlKeyword transaction transactional tries true
450 syn keyword sqlKeyword tsequal type tune uncommitted unconditionally
451 syn keyword sqlKeyword unenforced unique union unknown unload
452 syn keyword sqlKeyword updating updlock upgrade upload use user
453 syn keyword sqlKeyword using utc utilities validproc
454 syn keyword sqlKeyword value values varchar variable
455 syn keyword sqlKeyword varying vcat verify view virtual wait
456 syn keyword sqlKeyword warning web when where window with with_auto
457 syn keyword sqlKeyword with_auto with_cube with_rollup without
458 syn keyword sqlKeyword with_lparen within word work workload writefile
459 syn keyword sqlKeyword writers writeserver xlock zeros
460 " XML function support
461 syn keyword sqlFunction openxml xmlelement xmlforest xmlgen xmlconcat xmlagg
462 syn keyword sqlFunction xmlattributes
463 syn keyword sqlKeyword raw auto elements explicit
465 syn keyword sqlKeyword authorization secure url service
466 " HTTP 9.0.2 new procedure keywords
467 syn keyword sqlKeyword namespace certificate clientport proxy
469 syn keyword sqlKeyword covar_pop covar_samp corr regr_slope regr_intercept
470 syn keyword sqlKeyword regr_count regr_r2 regr_avgx regr_avgy
471 syn keyword sqlKeyword regr_sxx regr_syy regr_sxy
474 syn keyword sqlKeyword character dec options proc reference
475 syn keyword sqlKeyword subtrans tran syn keyword
478 syn keyword sqlOperator in any some all between exists
479 syn keyword sqlOperator like escape not is and or
480 syn keyword sqlOperator intersect minus
481 syn keyword sqlOperator prior distinct
483 syn keyword sqlStatement allocate alter backup begin call case
484 syn keyword sqlStatement checkpoint clear close commit configure connect
485 syn keyword sqlStatement create deallocate declare delete describe
486 syn keyword sqlStatement disconnect drop execute exit explain fetch
487 syn keyword sqlStatement for forward from get goto grant help if include
488 syn keyword sqlStatement input insert install leave load lock loop
489 syn keyword sqlStatement message open output parameter parameters passthrough
490 syn keyword sqlStatement prepare print put raiserror read readtext release
491 syn keyword sqlStatement remote remove reorganize resignal restore resume
492 syn keyword sqlStatement return revoke rollback savepoint select
493 syn keyword sqlStatement set setuser signal start stop synchronize
494 syn keyword sqlStatement system trigger truncate unload update
495 syn keyword sqlStatement validate waitfor whenever while writetext
498 syn keyword sqlType char long varchar text
499 syn keyword sqlType bigint decimal double float int integer numeric
500 syn keyword sqlType smallint tinyint real
501 syn keyword sqlType money smallmoney
502 syn keyword sqlType bit
503 syn keyword sqlType date datetime smalldate time timestamp
504 syn keyword sqlType binary image varbinary uniqueidentifier
505 syn keyword sqlType xml unsigned
507 syn keyword sqlType varbit nchar nvarchar
509 syn keyword sqlOption Allow_nulls_by_default
510 syn keyword sqlOption Ansi_blanks
511 syn keyword sqlOption Ansi_close_cursors_on_rollback
512 syn keyword sqlOption Ansi_integer_overflow
513 syn keyword sqlOption Ansi_permissions
514 syn keyword sqlOption Ansi_update_constraints
515 syn keyword sqlOption Ansinull
516 syn keyword sqlOption Assume_distinct_servers
517 syn keyword sqlOption Auditing
518 syn keyword sqlOption Auditing_options
519 syn keyword sqlOption Auto_commit
520 syn keyword sqlOption Auto_refetch
521 syn keyword sqlOption Automatic_timestamp
522 syn keyword sqlOption Background_priority
523 syn keyword sqlOption Bell
524 syn keyword sqlOption Blob_threshold
525 syn keyword sqlOption Blocking
526 syn keyword sqlOption Blocking_timeout
527 syn keyword sqlOption Chained
528 syn keyword sqlOption Char_OEM_Translation
529 syn keyword sqlOption Checkpoint_time
530 syn keyword sqlOption Cis_option
531 syn keyword sqlOption Cis_rowset_size
532 syn keyword sqlOption Close_on_endtrans
533 syn keyword sqlOption Command_delimiter
534 syn keyword sqlOption Commit_on_exit
535 syn keyword sqlOption Compression
536 syn keyword sqlOption Connection_authentication
537 syn keyword sqlOption Continue_after_raiserror
538 syn keyword sqlOption Conversion_error
539 syn keyword sqlOption Cooperative_commit_timeout
540 syn keyword sqlOption Cooperative_commits
541 syn keyword sqlOption Database_authentication
542 syn keyword sqlOption Date_format
543 syn keyword sqlOption Date_order
544 syn keyword sqlOption Debug_messages
545 syn keyword sqlOption Dedicated_task
546 syn keyword sqlOption Default_timestamp_increment
547 syn keyword sqlOption Delayed_commit_timeout
548 syn keyword sqlOption Delayed_commits
549 syn keyword sqlOption Delete_old_logs
550 syn keyword sqlOption Describe_Java_Format
551 syn keyword sqlOption Divide_by_zero_error
552 syn keyword sqlOption Echo
553 syn keyword sqlOption Escape_character
554 syn keyword sqlOption Exclude_operators
555 syn keyword sqlOption Extended_join_syntax
556 syn keyword sqlOption External_remote_options
557 syn keyword sqlOption Fire_triggers
558 syn keyword sqlOption First_day_of_week
559 syn keyword sqlOption Float_as_double
560 syn keyword sqlOption For_xml_null_treatment
561 syn keyword sqlOption Force_view_creation
562 syn keyword sqlOption Global_database_id
563 syn keyword sqlOption Headings
564 syn keyword sqlOption Input_format
565 syn keyword sqlOption Integrated_server_name
566 syn keyword sqlOption Isolation_level
567 syn keyword sqlOption ISQL_command_timing
568 syn keyword sqlOption ISQL_escape_character
569 syn keyword sqlOption ISQL_field_separator
570 syn keyword sqlOption ISQL_log
571 syn keyword sqlOption ISQL_plan
572 syn keyword sqlOption ISQL_plan_cursor_sensitivity
573 syn keyword sqlOption ISQL_plan_cursor_writability
574 syn keyword sqlOption ISQL_quote
575 syn keyword sqlOption Java_heap_size
576 syn keyword sqlOption Java_input_output
577 syn keyword sqlOption Java_namespace_size
578 syn keyword sqlOption Java_page_buffer_size
579 syn keyword sqlOption Lock_rejected_rows
580 syn keyword sqlOption Log_deadlocks
581 syn keyword sqlOption Log_detailed_plans
582 syn keyword sqlOption Log_max_requests
583 syn keyword sqlOption Login_mode
584 syn keyword sqlOption Login_procedure
585 syn keyword sqlOption Max_cursor_count
586 syn keyword sqlOption Max_hash_size
587 syn keyword sqlOption Max_plans_cached
588 syn keyword sqlOption Max_recursive_iterations
589 syn keyword sqlOption Max_statement_count
590 syn keyword sqlOption Max_work_table_hash_size
591 syn keyword sqlOption Min_password_length
592 syn keyword sqlOption Nearest_century
593 syn keyword sqlOption Non_keywords
594 syn keyword sqlOption NULLS
595 syn keyword sqlOption ODBC_describe_binary_as_varbinary
596 syn keyword sqlOption ODBC_distinguish_char_and_varchar
597 syn keyword sqlOption On_Charset_conversion_failure
598 syn keyword sqlOption On_error
599 syn keyword sqlOption On_tsql_error
600 syn keyword sqlOption Optimistic_wait_for_commit
601 syn keyword sqlOption Optimization_goal
602 syn keyword sqlOption Optimization_level
603 syn keyword sqlOption Optimization_logging
604 syn keyword sqlOption Optimization_workload
605 syn keyword sqlOption Output_format
606 syn keyword sqlOption Output_length
607 syn keyword sqlOption Output_nulls
608 syn keyword sqlOption Percent_as_comment
609 syn keyword sqlOption Pinned_cursor_percent_of_cache
610 syn keyword sqlOption Precision
611 syn keyword sqlOption Prefetch
612 syn keyword sqlOption Preserve_source_format
613 syn keyword sqlOption Prevent_article_pkey_update
614 syn keyword sqlOption Qualify_owners
615 syn keyword sqlOption Query_plan_on_open
616 syn keyword sqlOption Quiet
617 syn keyword sqlOption Quote_all_identifiers
618 syn keyword sqlOption Quoted_identifier
619 syn keyword sqlOption Read_past_deleted
620 syn keyword sqlOption Recovery_time
621 syn keyword sqlOption Remote_idle_timeout
622 syn keyword sqlOption Replicate_all
623 syn keyword sqlOption Replication_error
624 syn keyword sqlOption Replication_error_piece
625 syn keyword sqlOption Return_date_time_as_string
626 syn keyword sqlOption Return_java_as_string
627 syn keyword sqlOption RI_Trigger_time
628 syn keyword sqlOption Rollback_on_deadlock
629 syn keyword sqlOption Row_counts
630 syn keyword sqlOption Save_remote_passwords
631 syn keyword sqlOption Scale
632 syn keyword sqlOption Screen_format
633 syn keyword sqlOption Sort_Collation
634 syn keyword sqlOption SQL_flagger_error_level
635 syn keyword sqlOption SQL_flagger_warning_level
636 syn keyword sqlOption SQLConnect
637 syn keyword sqlOption SQLStart
638 syn keyword sqlOption SR_Date_Format
639 syn keyword sqlOption SR_Time_Format
640 syn keyword sqlOption SR_TimeStamp_Format
641 syn keyword sqlOption Statistics
642 syn keyword sqlOption String_rtruncation
643 syn keyword sqlOption Subscribe_by_remote
644 syn keyword sqlOption Subsume_row_locks
645 syn keyword sqlOption Suppress_TDS_debugging
646 syn keyword sqlOption TDS_Empty_string_is_null
647 syn keyword sqlOption Temp_space_limit_check
648 syn keyword sqlOption Thread_count
649 syn keyword sqlOption Thread_stack
650 syn keyword sqlOption Thread_swaps
651 syn keyword sqlOption Time_format
652 syn keyword sqlOption Time_zone_adjustment
653 syn keyword sqlOption Timestamp_format
654 syn keyword sqlOption Truncate_date_values
655 syn keyword sqlOption Truncate_timestamp_values
656 syn keyword sqlOption Truncate_with_auto_commit
657 syn keyword sqlOption Truncation_length
658 syn keyword sqlOption Tsql_hex_constant
659 syn keyword sqlOption Tsql_variables
660 syn keyword sqlOption Update_statistics
661 syn keyword sqlOption User_estimates
662 syn keyword sqlOption Verify_all_columns
663 syn keyword sqlOption Verify_threshold
664 syn keyword sqlOption Wait_for_commit
666 " Strings and characters:
667 syn region sqlString start=+"+ end=+"+ contains=@Spell
668 syn region sqlString start=+'+ end=+'+ contains=@Spell
671 syn match sqlNumber "-\=\<\d*\.\=[0-9_]\>"
674 syn region sqlDashComment start=/--/ end=/$/ contains=@Spell
675 syn region sqlSlashComment start=/\/\// end=/$/ contains=@Spell
676 syn region sqlMultiComment start="/\*" end="\*/" contains=sqlMultiComment,@Spell
677 syn cluster sqlComment contains=sqlDashComment,sqlSlashComment,sqlMultiComment,@Spell
678 syn sync ccomment sqlComment
679 syn sync ccomment sqlDashComment
680 syn sync ccomment sqlSlashComment
682 " Define the default highlighting.
683 " For version 5.7 and earlier: only when not done already
684 " For version 5.8 and later: only when an item doesn't have highlighting yet
685 if version >= 508 || !exists("did_sql_syn_inits")
687 let did_sql_syn_inits = 1
688 command -nargs=+ HiLink hi link <args>
690 command -nargs=+ HiLink hi link <args>
693 HiLink sqlDashComment Comment
694 HiLink sqlSlashComment Comment
695 HiLink sqlMultiComment Comment
696 HiLink sqlNumber Number
697 HiLink sqlOperator Operator
698 HiLink sqlSpecial Special
699 HiLink sqlKeyword Keyword
700 HiLink sqlStatement Statement
701 HiLink sqlString String
703 HiLink sqlFunction Function
704 HiLink sqlOption PreProc
709 let b:current_syntax = "sqlanywhere"