blob: 5abab381ea40eb5075f314d50a8890d27e30bdff [file] [log] [blame]
Bram Moolenaar446cb832008-06-24 21:56:24 +00001
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +00002" Vim syntax file
3" Language: SQL, Adaptive Server Anywhere
4" Maintainer: David Fishburn <fishburn at ianywhere dot com>
Bram Moolenaar5c736222010-01-06 20:54:52 +01005" Last Change: 2009 Mar 15
6" Version: 11.0.1
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +00007
Bram Moolenaar5c736222010-01-06 20:54:52 +01008" Description: Updated to Adaptive Server Anywhere 11.0.1
9" Updated to Adaptive Server Anywhere 10.0.1
Bram Moolenaar446cb832008-06-24 21:56:24 +000010" 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
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +000013"
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
Bram Moolenaar446cb832008-06-24 21:56:24 +000029syn 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
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +000056
57" 9.0.1 functions
Bram Moolenaar5c736222010-01-06 20:54:52 +010058syn keyword sqlFunction acos asin atan atn2 cast ceiling convert cos cot
Bram Moolenaar446cb832008-06-24 21:56:24 +000059syn keyword sqlFunction char_length coalesce dateformat datetime degrees exp
Bram Moolenaar5c736222010-01-06 20:54:52 +010060syn keyword sqlFunction floor getdate insertstr
Bram Moolenaar446cb832008-06-24 21:56:24 +000061syn keyword sqlFunction log log10 lower mod pi power
Bram Moolenaar5c736222010-01-06 20:54:52 +010062syn keyword sqlFunction property radians replicate round sign sin
Bram Moolenaar446cb832008-06-24 21:56:24 +000063syn keyword sqlFunction sqldialect tan truncate truncnum
64syn keyword sqlFunction base64_encode base64_decode
65syn keyword sqlFunction hash compress decompress encrypt decrypt
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +000066
Bram Moolenaar5c736222010-01-06 20:54:52 +010067" 11.0.1 functions
68syn keyword sqlFunction connection_extended_property text_handle_vector_match
69syn keyword sqlFunction read_client_file write_client_file
70
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +000071" string functions
Bram Moolenaar446cb832008-06-24 21:56:24 +000072syn keyword sqlFunction ascii char left ltrim repeat
73syn keyword sqlFunction space right rtrim trim lcase ucase
74syn keyword sqlFunction locate charindex patindex replace
Bram Moolenaar5c736222010-01-06 20:54:52 +010075syn keyword sqlFunction errormsg csconvert
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +000076
77" property functions
Bram Moolenaar446cb832008-06-24 21:56:24 +000078syn 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
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +000083
84" sa_ procedures
Bram Moolenaar446cb832008-06-24 21:56:24 +000085syn 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
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000201
202" sp_ procedures
Bram Moolenaar446cb832008-06-24 21:56:24 +0000203syn 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
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000331
332" server functions
Bram Moolenaar446cb832008-06-24 21:56:24 +0000333syn 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
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000359
360" http functions
Bram Moolenaar446cb832008-06-24 21:56:24 +0000361syn 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
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000365
Bram Moolenaar5c736222010-01-06 20:54:52 +0100366" http functions 9.0.1
Bram Moolenaar446cb832008-06-24 21:56:24 +0000367syn keyword sqlFunction http_encode http_decode
368syn keyword sqlFunction html_encode html_decode
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000369
370" keywords
Bram Moolenaar5c736222010-01-06 20:54:52 +0100371syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000375syn keyword sqlKeyword autoincrement autostop batch bcp before
Bram Moolenaar5c736222010-01-06 20:54:52 +0100376syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000379syn keyword sqlKeyword build bulk by byte bytes cache calibrate calibration
380syn keyword sqlKeyword cancel capability cascade cast
Bram Moolenaar5c736222010-01-06 20:54:52 +0100381syn keyword sqlKeyword catalog ceil changes char char_convert check checksum
Bram Moolenaar446cb832008-06-24 21:56:24 +0000382syn keyword sqlKeyword class classes client cmp
Bram Moolenaar5c736222010-01-06 20:54:52 +0100383syn keyword sqlKeyword cluster clustered collation
384syn keyword sqlKeyword column columns
Bram Moolenaar446cb832008-06-24 21:56:24 +0000385syn keyword sqlKeyword command comment committed comparisons
386syn keyword sqlKeyword compatible component compressed compute computes
Bram Moolenaar5c736222010-01-06 20:54:52 +0100387syn keyword sqlKeyword concat configuration confirm conflict connection
Bram Moolenaar446cb832008-06-24 21:56:24 +0000388syn keyword sqlKeyword console consolidate consolidated
Bram Moolenaar5c736222010-01-06 20:54:52 +0100389syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000392syn keyword sqlKeyword current cursor data data database
393syn keyword sqlKeyword current_timestamp current_user
Bram Moolenaar5c736222010-01-06 20:54:52 +0100394syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000398syn keyword sqlKeyword delay deleting delimited dependencies desc
399syn keyword sqlKeyword description detach deterministic directory
Bram Moolenaar5c736222010-01-06 20:54:52 +0100400syn keyword sqlKeyword disable disabled distinct do domain download duplicate
Bram Moolenaar446cb832008-06-24 21:56:24 +0000401syn keyword sqlKeyword dsetpass dttm dynamic each editproc ejb
Bram Moolenaar5c736222010-01-06 20:54:52 +0100402syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000406syn keyword sqlKeyword external externlogin factor failover false
Bram Moolenaar5c736222010-01-06 20:54:52 +0100407syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000414syn keyword sqlKeyword ignore_dup_key ignore_dup_row immediate
Bram Moolenaar5c736222010-01-06 20:54:52 +0100415syn keyword sqlKeyword in inactiv inactive inactivity included incremental
416syn keyword sqlKeyword index index_enabled index_lparen indexonly info
Bram Moolenaar446cb832008-06-24 21:56:24 +0000417syn keyword sqlKeyword inline inner inout insensitive inserting
418syn keyword sqlKeyword instead integrated
Bram Moolenaar5c736222010-01-06 20:54:52 +0100419syn keyword sqlKeyword internal intersection into introduced invoker iq is isolation
420syn keyword sqlKeyword jar java java_location java_main_userid java_vm_options
Bram Moolenaar446cb832008-06-24 21:56:24 +0000421syn keyword sqlKeyword jconnect jdk join kb key keep kerberos language last
Bram Moolenaar5c736222010-01-06 20:54:52 +0100422syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000428syn keyword sqlKeyword noholdlock nolock nonclustered none not
Bram Moolenaar5c736222010-01-06 20:54:52 +0100429syn keyword sqlKeyword notify null nullable_constant nulls object oem_string of off offline
430syn keyword sqlKeyword old on online only openstring optimization optimizer option
Bram Moolenaar446cb832008-06-24 21:56:24 +0000431syn keyword sqlKeyword or order others out outer over
432syn keyword sqlKeyword package packetsize padding page pages
Bram Moolenaar5c736222010-01-06 20:54:52 +0100433syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000439syn keyword sqlKeyword readpast readuncommitted readwrite rebuild
440syn keyword sqlKeyword received recompile recover recursive references
Bram Moolenaar5c736222010-01-06 20:54:52 +0100441syn keyword sqlKeyword referencing refresh regex regexp regexp_substr relative relocate
Bram Moolenaar446cb832008-06-24 21:56:24 +0000442syn keyword sqlKeyword rename repeatable repeatableread
Bram Moolenaar5c736222010-01-06 20:54:52 +0100443syn keyword sqlKeyword replicate request_timeout required rereceive resend reserve reset
Bram Moolenaar446cb832008-06-24 21:56:24 +0000444syn keyword sqlKeyword resizing resolve resource respect
445syn keyword sqlKeyword restrict result retain
Bram Moolenaar5c736222010-01-06 20:54:52 +0100446syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000451syn keyword sqlKeyword send sensitive sent serializable
Bram Moolenaar5c736222010-01-06 20:54:52 +0100452syn keyword sqlKeyword server server session set_bit set_bits sets
Bram Moolenaar446cb832008-06-24 21:56:24 +0000453syn keyword sqlKeyword share simple since site size skip
Bram Moolenaar5c736222010-01-06 20:54:52 +0100454syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000460syn keyword sqlKeyword syntax_error table tablock
Bram Moolenaar5c736222010-01-06 20:54:52 +0100461syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000464syn keyword sqlKeyword tsequal type tune uncommitted unconditionally
Bram Moolenaar5c736222010-01-06 20:54:52 +0100465syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000468syn keyword sqlKeyword using utc utilities validproc
469syn keyword sqlKeyword value values varchar variable
Bram Moolenaar5c736222010-01-06 20:54:52 +0100470syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000472syn keyword sqlKeyword with_auto with_cube with_rollup without
Bram Moolenaar5c736222010-01-06 20:54:52 +0100473syn keyword sqlKeyword with_lparen within word work workload write writefile
474syn keyword sqlKeyword writeclientfile writer writers writeserver xlock zeros
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000475" XML function support
Bram Moolenaar5c736222010-01-06 20:54:52 +0100476syn keyword sqlFunction openxml xmlelement xmlforest xmlgen xmlconcat xmlagg
477syn keyword sqlFunction xmlattributes
Bram Moolenaar446cb832008-06-24 21:56:24 +0000478syn keyword sqlKeyword raw auto elements explicit
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000479" HTTP support
Bram Moolenaar5c736222010-01-06 20:54:52 +0100480syn keyword sqlKeyword authorization secure url service next_soap_header
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000481" HTTP 9.0.2 new procedure keywords
Bram Moolenaar446cb832008-06-24 21:56:24 +0000482syn keyword sqlKeyword namespace certificate clientport proxy
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000483" OLAP support 9.0.0
Bram Moolenaar5c736222010-01-06 20:54:52 +0100484syn keyword sqlKeyword covar_pop covar_samp corr regr_slope regr_intercept
Bram Moolenaar446cb832008-06-24 21:56:24 +0000485syn keyword sqlKeyword regr_count regr_r2 regr_avgx regr_avgy
486syn keyword sqlKeyword regr_sxx regr_syy regr_sxy
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000487
488" Alternate keywords
Bram Moolenaar446cb832008-06-24 21:56:24 +0000489syn keyword sqlKeyword character dec options proc reference
Bram Moolenaar5c736222010-01-06 20:54:52 +0100490syn keyword sqlKeyword subtrans tran syn keyword
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000491
492
Bram Moolenaar446cb832008-06-24 21:56:24 +0000493syn keyword sqlOperator in any some all between exists
Bram Moolenaar5c736222010-01-06 20:54:52 +0100494syn keyword sqlOperator like escape not is and or
Bram Moolenaar446cb832008-06-24 21:56:24 +0000495syn keyword sqlOperator intersect minus
496syn keyword sqlOperator prior distinct
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000497
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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000513syn keyword sqlType char long varchar text
Bram Moolenaar5c736222010-01-06 20:54:52 +0100514syn keyword sqlType bigint decimal double float int integer numeric
Bram Moolenaar446cb832008-06-24 21:56:24 +0000515syn keyword sqlType smallint tinyint real
516syn keyword sqlType money smallmoney
Bram Moolenaar5c736222010-01-06 20:54:52 +0100517syn keyword sqlType bit
518syn keyword sqlType date datetime smalldate time timestamp
Bram Moolenaar446cb832008-06-24 21:56:24 +0000519syn keyword sqlType binary image varbinary uniqueidentifier
520syn keyword sqlType xml unsigned
521" New types 10.0.0
522syn keyword sqlType varbit nchar nvarchar
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000523
Bram Moolenaar446cb832008-06-24 21:56:24 +0000524syn keyword sqlOption Allow_nulls_by_default
Bram Moolenaar5c736222010-01-06 20:54:52 +0100525syn keyword sqlOption Allow_read_client_file
526syn keyword sqlOption Allow_snapshot_isolation
527syn keyword sqlOption Allow_write_client_file
Bram Moolenaar446cb832008-06-24 21:56:24 +0000528syn keyword sqlOption Ansi_blanks
529syn keyword sqlOption Ansi_close_cursors_on_rollback
Bram Moolenaar446cb832008-06-24 21:56:24 +0000530syn keyword sqlOption Ansi_permissions
Bram Moolenaar5c736222010-01-06 20:54:52 +0100531syn keyword sqlOption Ansi_substring
Bram Moolenaar446cb832008-06-24 21:56:24 +0000532syn keyword sqlOption Ansi_update_constraints
533syn keyword sqlOption Ansinull
Bram Moolenaar446cb832008-06-24 21:56:24 +0000534syn keyword sqlOption Auditing
535syn keyword sqlOption Auditing_options
Bram Moolenaar446cb832008-06-24 21:56:24 +0000536syn keyword sqlOption Background_priority
Bram Moolenaar446cb832008-06-24 21:56:24 +0000537syn keyword sqlOption Blocking
538syn keyword sqlOption Blocking_timeout
539syn keyword sqlOption Chained
Bram Moolenaar446cb832008-06-24 21:56:24 +0000540syn keyword sqlOption Checkpoint_time
541syn keyword sqlOption Cis_option
542syn keyword sqlOption Cis_rowset_size
543syn keyword sqlOption Close_on_endtrans
Bram Moolenaar5c736222010-01-06 20:54:52 +0100544syn keyword sqlOption Collect_statistics_on_dml_updates
545syn keyword sqlOption Conn_auditing
Bram Moolenaar446cb832008-06-24 21:56:24 +0000546syn 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
Bram Moolenaar5c736222010-01-06 20:54:52 +0100556syn keyword sqlOption Default_dbspace
Bram Moolenaar446cb832008-06-24 21:56:24 +0000557syn keyword sqlOption Default_timestamp_increment
558syn keyword sqlOption Delayed_commit_timeout
559syn keyword sqlOption Delayed_commits
Bram Moolenaar446cb832008-06-24 21:56:24 +0000560syn keyword sqlOption Escape_character
561syn keyword sqlOption Exclude_operators
562syn keyword sqlOption Extended_join_syntax
Bram Moolenaar446cb832008-06-24 21:56:24 +0000563syn keyword sqlOption Fire_triggers
564syn keyword sqlOption First_day_of_week
Bram Moolenaar446cb832008-06-24 21:56:24 +0000565syn keyword sqlOption For_xml_null_treatment
566syn keyword sqlOption Force_view_creation
567syn keyword sqlOption Global_database_id
Bram Moolenaar5c736222010-01-06 20:54:52 +0100568syn keyword sqlOption Http_session_timeout
Bram Moolenaar446cb832008-06-24 21:56:24 +0000569syn keyword sqlOption Integrated_server_name
570syn keyword sqlOption Isolation_level
Bram Moolenaar5c736222010-01-06 20:54:52 +0100571syn keyword sqlOption Java_location
572syn keyword sqlOption Java_main_userid
573syn keyword sqlOption Java_vm_options
Bram Moolenaar446cb832008-06-24 21:56:24 +0000574syn keyword sqlOption Lock_rejected_rows
575syn keyword sqlOption Log_deadlocks
Bram Moolenaar446cb832008-06-24 21:56:24 +0000576syn keyword sqlOption Login_mode
577syn keyword sqlOption Login_procedure
Bram Moolenaar5c736222010-01-06 20:54:52 +0100578syn keyword sqlOption Materialized_view_optimization
579syn keyword sqlOption Max_client_statements_cached
Bram Moolenaar446cb832008-06-24 21:56:24 +0000580syn keyword sqlOption Max_cursor_count
581syn keyword sqlOption Max_hash_size
582syn keyword sqlOption Max_plans_cached
Bram Moolenaar5c736222010-01-06 20:54:52 +0100583syn keyword sqlOption Max_priority
584syn keyword sqlOption Max_query_tasks
Bram Moolenaar446cb832008-06-24 21:56:24 +0000585syn keyword sqlOption Max_recursive_iterations
586syn keyword sqlOption Max_statement_count
Bram Moolenaar5c736222010-01-06 20:54:52 +0100587syn keyword sqlOption Max_temp_space
Bram Moolenaar446cb832008-06-24 21:56:24 +0000588syn keyword sqlOption Min_password_length
589syn keyword sqlOption Nearest_century
590syn keyword sqlOption Non_keywords
Bram Moolenaar5c736222010-01-06 20:54:52 +0100591syn 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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000595syn keyword sqlOption On_tsql_error
Bram Moolenaar446cb832008-06-24 21:56:24 +0000596syn keyword sqlOption Optimization_goal
597syn keyword sqlOption Optimization_level
Bram Moolenaar446cb832008-06-24 21:56:24 +0000598syn keyword sqlOption Optimization_workload
Bram Moolenaar446cb832008-06-24 21:56:24 +0000599syn keyword sqlOption Pinned_cursor_percent_of_cache
Bram Moolenaar5c736222010-01-06 20:54:52 +0100600syn keyword sqlOption Post_login_procedure
Bram Moolenaar446cb832008-06-24 21:56:24 +0000601syn keyword sqlOption Precision
602syn keyword sqlOption Prefetch
603syn keyword sqlOption Preserve_source_format
604syn keyword sqlOption Prevent_article_pkey_update
Bram Moolenaar5c736222010-01-06 20:54:52 +0100605syn keyword sqlOption Priority
606syn keyword sqlOption Query_mem_timeout
Bram Moolenaar446cb832008-06-24 21:56:24 +0000607syn 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
Bram Moolenaar5c736222010-01-06 20:54:52 +0100612syn keyword sqlOption Request_timeout
Bram Moolenaar446cb832008-06-24 21:56:24 +0000613syn keyword sqlOption Return_date_time_as_string
Bram Moolenaar446cb832008-06-24 21:56:24 +0000614syn keyword sqlOption Rollback_on_deadlock
615syn keyword sqlOption Row_counts
Bram Moolenaar446cb832008-06-24 21:56:24 +0000616syn keyword sqlOption Scale
Bram Moolenaar5c736222010-01-06 20:54:52 +0100617syn keyword sqlOption Secure_feature_key
618syn keyword sqlOption Sort_collation
619syn keyword sqlOption Sql_flagger_error_level
620syn keyword sqlOption Sql_flagger_warning_level
Bram Moolenaar446cb832008-06-24 21:56:24 +0000621syn keyword sqlOption String_rtruncation
Bram Moolenaar446cb832008-06-24 21:56:24 +0000622syn keyword sqlOption Subsume_row_locks
Bram Moolenaar5c736222010-01-06 20:54:52 +0100623syn keyword sqlOption Suppress_tds_debugging
624syn keyword sqlOption Synchronize_mirror_on_commit
625syn keyword sqlOption Tds_empty_string_is_null
Bram Moolenaar446cb832008-06-24 21:56:24 +0000626syn keyword sqlOption Temp_space_limit_check
Bram Moolenaar446cb832008-06-24 21:56:24 +0000627syn keyword sqlOption Time_format
628syn keyword sqlOption Time_zone_adjustment
629syn keyword sqlOption Timestamp_format
Bram Moolenaar446cb832008-06-24 21:56:24 +0000630syn keyword sqlOption Truncate_timestamp_values
Bram Moolenaar5c736222010-01-06 20:54:52 +0100631syn keyword sqlOption Tsql_outer_joins
Bram Moolenaar446cb832008-06-24 21:56:24 +0000632syn keyword sqlOption Tsql_variables
Bram Moolenaar5c736222010-01-06 20:54:52 +0100633syn keyword sqlOption Updatable_statement_isolation
Bram Moolenaar446cb832008-06-24 21:56:24 +0000634syn keyword sqlOption Update_statistics
Bram Moolenaar5c736222010-01-06 20:54:52 +0100635syn keyword sqlOption Upgrade_database_capability
Bram Moolenaar446cb832008-06-24 21:56:24 +0000636syn keyword sqlOption User_estimates
Bram Moolenaar5c736222010-01-06 20:54:52 +0100637syn keyword sqlOption Verify_password_function
Bram Moolenaar446cb832008-06-24 21:56:24 +0000638syn keyword sqlOption Wait_for_commit
Bram Moolenaar5c736222010-01-06 20:54:52 +0100639syn keyword sqlOption Webservice_namespace_host
Bram Moolenaar4ea8fe12006-03-09 22:32:39 +0000640
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
Bram Moolenaar446cb832008-06-24 21:56:24 +0000686" vim:sw=4: