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