Mercurial > hg > RemoteEditor > vim7

comparison runtime/syntax/sqlanywhere.vim @ 0:76efa0be13f1

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