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