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