1" Vim syntax file 2" Language: SQL, Adaptive Server Anywhere 3" Maintainer: David Fishburn <dfishburn dot vim at gmail dot com> 4" Last Change: 2013 May 13 5" Version: 16.0.0 6 7" Description: Updated to Adaptive Server Anywhere 16.0.0 8" Updated to Adaptive Server Anywhere 12.0.1 (including spatial data) 9" Updated to Adaptive Server Anywhere 11.0.1 10" Updated to Adaptive Server Anywhere 10.0.1 11" Updated to Adaptive Server Anywhere 9.0.2 12" Updated to Adaptive Server Anywhere 9.0.1 13" Updated to Adaptive Server Anywhere 9.0.0 14" 15" quit when a syntax file was already loaded 16if exists("b:current_syntax") 17 finish 18endif 19 20syn case ignore 21 22" The SQL reserved words, defined as keywords. 23 24syn keyword sqlSpecial false null true 25 26" common functions 27syn keyword sqlFunction abs argn avg bintohex bintostr 28syn keyword sqlFunction byte_length byte_substr char_length 29syn keyword sqlFunction compare count count_big datalength date 30syn keyword sqlFunction date_format dateadd datediff datename 31syn keyword sqlFunction datepart day dayname days debug_eng 32syn keyword sqlFunction dense_rank density dialect difference 33syn keyword sqlFunction dow estimate estimate_source evaluate 34syn keyword sqlFunction experience_estimate explanation 35syn keyword sqlFunction get_identity graphical_plan 36syn keyword sqlFunction graphical_ulplan greater grouping 37syn keyword sqlFunction hextobin hextoint hour hours identity 38syn keyword sqlFunction ifnull index_estimate inttohex isdate 39syn keyword sqlFunction isencrypted isnull isnumeric 40syn keyword sqlFunction lang_message length lesser like_end 41syn keyword sqlFunction like_start list long_ulplan lookup max 42syn keyword sqlFunction min minute minutes month monthname 43syn keyword sqlFunction months newid now nullif number 44syn keyword sqlFunction percent_rank plan quarter rand rank 45syn keyword sqlFunction regexp_compile regexp_compile_patindex 46syn keyword sqlFunction remainder rewrite rowid second seconds 47syn keyword sqlFunction short_ulplan similar sortkey soundex 48syn keyword sqlFunction stddev stack_trace str string strtobin strtouuid stuff 49syn keyword sqlFunction subpartition substr substring sum switchoffset sysdatetimeoffset 50syn keyword sqlFunction textptr todate todatetimeoffset today totimestamp traceback transactsql 51syn keyword sqlFunction ts_index_statistics ts_table_statistics 52syn keyword sqlFunction tsequal ulplan user_id user_name utc_now 53syn keyword sqlFunction uuidtostr varexists variance watcomsql 54syn keyword sqlFunction weeks wsql_state year years ymd 55 56" 9.0.1 functions 57syn keyword sqlFunction acos asin atan atn2 cast ceiling convert cos cot 58syn keyword sqlFunction char_length coalesce dateformat datetime degrees exp 59syn keyword sqlFunction floor getdate insertstr 60syn keyword sqlFunction log log10 lower mod pi power 61syn keyword sqlFunction property radians replicate round sign sin 62syn keyword sqlFunction sqldialect tan truncate truncnum 63syn keyword sqlFunction base64_encode base64_decode 64syn keyword sqlFunction hash compress decompress encrypt decrypt 65 66" 11.0.1 functions 67syn keyword sqlFunction connection_extended_property text_handle_vector_match 68syn keyword sqlFunction read_client_file write_client_file 69 70" 12.0.1 functions 71syn keyword sqlFunction http_response_header 72 73" string functions 74syn keyword sqlFunction ascii char left ltrim repeat 75syn keyword sqlFunction space right rtrim trim lcase ucase 76syn keyword sqlFunction locate charindex patindex replace 77syn keyword sqlFunction errormsg csconvert 78 79" property functions 80syn keyword sqlFunction db_id db_name property_name 81syn keyword sqlFunction property_description property_number 82syn keyword sqlFunction next_connection next_database property 83syn keyword sqlFunction connection_property db_property db_extended_property 84syn keyword sqlFunction event_parmeter event_condition event_condition_name 85 86" sa_ procedures 87syn keyword sqlFunction sa_add_index_consultant_analysis 88syn keyword sqlFunction sa_add_workload_query 89syn keyword sqlFunction sa_app_deregister 90syn keyword sqlFunction sa_app_get_infoStr 91syn keyword sqlFunction sa_app_get_status 92syn keyword sqlFunction sa_app_register 93syn keyword sqlFunction sa_app_registration_unlock 94syn keyword sqlFunction sa_app_set_infoStr 95syn keyword sqlFunction sa_audit_string 96syn keyword sqlFunction sa_check_commit 97syn keyword sqlFunction sa_checkpoint_execute 98syn keyword sqlFunction sa_conn_activity 99syn keyword sqlFunction sa_conn_compression_info 100syn keyword sqlFunction sa_conn_deregister 101syn keyword sqlFunction sa_conn_info 102syn keyword sqlFunction sa_conn_properties 103syn keyword sqlFunction sa_conn_properties_by_conn 104syn keyword sqlFunction sa_conn_properties_by_name 105syn keyword sqlFunction sa_conn_register 106syn keyword sqlFunction sa_conn_set_status 107syn keyword sqlFunction sa_create_analysis_from_query 108syn keyword sqlFunction sa_db_info 109syn keyword sqlFunction sa_db_properties 110syn keyword sqlFunction sa_disable_auditing_type 111syn keyword sqlFunction sa_disable_index 112syn keyword sqlFunction sa_disk_free_space 113syn keyword sqlFunction sa_enable_auditing_type 114syn keyword sqlFunction sa_enable_index 115syn keyword sqlFunction sa_end_forward_to 116syn keyword sqlFunction sa_eng_properties 117syn keyword sqlFunction sa_event_schedules 118syn keyword sqlFunction sa_exec_script 119syn keyword sqlFunction sa_flush_cache 120syn keyword sqlFunction sa_flush_statistics 121syn keyword sqlFunction sa_forward_to 122syn keyword sqlFunction sa_get_dtt 123syn keyword sqlFunction sa_get_histogram 124syn keyword sqlFunction sa_get_request_profile 125syn keyword sqlFunction sa_get_request_profile_sub 126syn keyword sqlFunction sa_get_request_times 127syn keyword sqlFunction sa_get_server_messages 128syn keyword sqlFunction sa_get_simulated_scale_factors 129syn keyword sqlFunction sa_get_workload_capture_status 130syn keyword sqlFunction sa_index_density 131syn keyword sqlFunction sa_index_levels 132syn keyword sqlFunction sa_index_statistics 133syn keyword sqlFunction sa_internal_alter_index_ability 134syn keyword sqlFunction sa_internal_create_analysis_from_query 135syn keyword sqlFunction sa_internal_disk_free_space 136syn keyword sqlFunction sa_internal_get_dtt 137syn keyword sqlFunction sa_internal_get_histogram 138syn keyword sqlFunction sa_internal_get_request_times 139syn keyword sqlFunction sa_internal_get_simulated_scale_factors 140syn keyword sqlFunction sa_internal_get_workload_capture_status 141syn keyword sqlFunction sa_internal_index_density 142syn keyword sqlFunction sa_internal_index_levels 143syn keyword sqlFunction sa_internal_index_statistics 144syn keyword sqlFunction sa_internal_java_loaded_classes 145syn keyword sqlFunction sa_internal_locks 146syn keyword sqlFunction sa_internal_pause_workload_capture 147syn keyword sqlFunction sa_internal_procedure_profile 148syn keyword sqlFunction sa_internal_procedure_profile_summary 149syn keyword sqlFunction sa_internal_read_backup_history 150syn keyword sqlFunction sa_internal_recommend_indexes 151syn keyword sqlFunction sa_internal_reset_identity 152syn keyword sqlFunction sa_internal_resume_workload_capture 153syn keyword sqlFunction sa_internal_start_workload_capture 154syn keyword sqlFunction sa_internal_stop_index_consultant 155syn keyword sqlFunction sa_internal_stop_workload_capture 156syn keyword sqlFunction sa_internal_table_fragmentation 157syn keyword sqlFunction sa_internal_table_page_usage 158syn keyword sqlFunction sa_internal_table_stats 159syn keyword sqlFunction sa_internal_virtual_sysindex 160syn keyword sqlFunction sa_internal_virtual_sysixcol 161syn keyword sqlFunction sa_java_loaded_classes 162syn keyword sqlFunction sa_jdk_version 163syn keyword sqlFunction sa_locks 164syn keyword sqlFunction sa_make_object 165syn keyword sqlFunction sa_pause_workload_capture 166syn keyword sqlFunction sa_proc_debug_attach_to_connection 167syn keyword sqlFunction sa_proc_debug_connect 168syn keyword sqlFunction sa_proc_debug_detach_from_connection 169syn keyword sqlFunction sa_proc_debug_disconnect 170syn keyword sqlFunction sa_proc_debug_get_connection_name 171syn keyword sqlFunction sa_proc_debug_release_connection 172syn keyword sqlFunction sa_proc_debug_request 173syn keyword sqlFunction sa_proc_debug_version 174syn keyword sqlFunction sa_proc_debug_wait_for_connection 175syn keyword sqlFunction sa_procedure_profile 176syn keyword sqlFunction sa_procedure_profile_summary 177syn keyword sqlFunction sa_read_backup_history 178syn keyword sqlFunction sa_recommend_indexes 179syn keyword sqlFunction sa_recompile_views 180syn keyword sqlFunction sa_remove_index_consultant_analysis 181syn keyword sqlFunction sa_remove_index_consultant_workload 182syn keyword sqlFunction sa_reset_identity 183syn keyword sqlFunction sa_resume_workload_capture 184syn keyword sqlFunction sa_server_option 185syn keyword sqlFunction sa_set_simulated_scale_factor 186syn keyword sqlFunction sa_setremoteuser 187syn keyword sqlFunction sa_setsubscription 188syn keyword sqlFunction sa_start_recording_commits 189syn keyword sqlFunction sa_start_workload_capture 190syn keyword sqlFunction sa_statement_text 191syn keyword sqlFunction sa_stop_index_consultant 192syn keyword sqlFunction sa_stop_recording_commits 193syn keyword sqlFunction sa_stop_workload_capture 194syn keyword sqlFunction sa_sync 195syn keyword sqlFunction sa_sync_sub 196syn keyword sqlFunction sa_table_fragmentation 197syn keyword sqlFunction sa_table_page_usage 198syn keyword sqlFunction sa_table_stats 199syn keyword sqlFunction sa_update_index_consultant_workload 200syn keyword sqlFunction sa_validate 201syn keyword sqlFunction sa_virtual_sysindex 202syn keyword sqlFunction sa_virtual_sysixcol 203 204" sp_ procedures 205syn keyword sqlFunction sp_addalias 206syn keyword sqlFunction sp_addauditrecord 207syn keyword sqlFunction sp_adddumpdevice 208syn keyword sqlFunction sp_addgroup 209syn keyword sqlFunction sp_addlanguage 210syn keyword sqlFunction sp_addlogin 211syn keyword sqlFunction sp_addmessage 212syn keyword sqlFunction sp_addremotelogin 213syn keyword sqlFunction sp_addsegment 214syn keyword sqlFunction sp_addserver 215syn keyword sqlFunction sp_addthreshold 216syn keyword sqlFunction sp_addtype 217syn keyword sqlFunction sp_adduser 218syn keyword sqlFunction sp_auditdatabase 219syn keyword sqlFunction sp_auditlogin 220syn keyword sqlFunction sp_auditobject 221syn keyword sqlFunction sp_auditoption 222syn keyword sqlFunction sp_auditsproc 223syn keyword sqlFunction sp_bindefault 224syn keyword sqlFunction sp_bindmsg 225syn keyword sqlFunction sp_bindrule 226syn keyword sqlFunction sp_changedbowner 227syn keyword sqlFunction sp_changegroup 228syn keyword sqlFunction sp_checknames 229syn keyword sqlFunction sp_checkperms 230syn keyword sqlFunction sp_checkreswords 231syn keyword sqlFunction sp_clearstats 232syn keyword sqlFunction sp_column_privileges 233syn keyword sqlFunction sp_columns 234syn keyword sqlFunction sp_commonkey 235syn keyword sqlFunction sp_configure 236syn keyword sqlFunction sp_cursorinfo 237syn keyword sqlFunction sp_databases 238syn keyword sqlFunction sp_datatype_info 239syn keyword sqlFunction sp_dboption 240syn keyword sqlFunction sp_dbremap 241syn keyword sqlFunction sp_depends 242syn keyword sqlFunction sp_diskdefault 243syn keyword sqlFunction sp_displaylogin 244syn keyword sqlFunction sp_dropalias 245syn keyword sqlFunction sp_dropdevice 246syn keyword sqlFunction sp_dropgroup 247syn keyword sqlFunction sp_dropkey 248syn keyword sqlFunction sp_droplanguage 249syn keyword sqlFunction sp_droplogin 250syn keyword sqlFunction sp_dropmessage 251syn keyword sqlFunction sp_dropremotelogin 252syn keyword sqlFunction sp_dropsegment 253syn keyword sqlFunction sp_dropserver 254syn keyword sqlFunction sp_dropthreshold 255syn keyword sqlFunction sp_droptype 256syn keyword sqlFunction sp_dropuser 257syn keyword sqlFunction sp_estspace 258syn keyword sqlFunction sp_extendsegment 259syn keyword sqlFunction sp_fkeys 260syn keyword sqlFunction sp_foreignkey 261syn keyword sqlFunction sp_getmessage 262syn keyword sqlFunction sp_help 263syn keyword sqlFunction sp_helpconstraint 264syn keyword sqlFunction sp_helpdb 265syn keyword sqlFunction sp_helpdevice 266syn keyword sqlFunction sp_helpgroup 267syn keyword sqlFunction sp_helpindex 268syn keyword sqlFunction sp_helpjoins 269syn keyword sqlFunction sp_helpkey 270syn keyword sqlFunction sp_helplanguage 271syn keyword sqlFunction sp_helplog 272syn keyword sqlFunction sp_helpprotect 273syn keyword sqlFunction sp_helpremotelogin 274syn keyword sqlFunction sp_helpsegment 275syn keyword sqlFunction sp_helpserver 276syn keyword sqlFunction sp_helpsort 277syn keyword sqlFunction sp_helptext 278syn keyword sqlFunction sp_helpthreshold 279syn keyword sqlFunction sp_helpuser 280syn keyword sqlFunction sp_indsuspect 281syn keyword sqlFunction sp_lock 282syn keyword sqlFunction sp_locklogin 283syn keyword sqlFunction sp_logdevice 284syn keyword sqlFunction sp_login_environment 285syn keyword sqlFunction sp_modifylogin 286syn keyword sqlFunction sp_modifythreshold 287syn keyword sqlFunction sp_monitor 288syn keyword sqlFunction sp_password 289syn keyword sqlFunction sp_pkeys 290syn keyword sqlFunction sp_placeobject 291syn keyword sqlFunction sp_primarykey 292syn keyword sqlFunction sp_procxmode 293syn keyword sqlFunction sp_recompile 294syn keyword sqlFunction sp_remap 295syn keyword sqlFunction sp_remote_columns 296syn keyword sqlFunction sp_remote_exported_keys 297syn keyword sqlFunction sp_remote_imported_keys 298syn keyword sqlFunction sp_remote_pcols 299syn keyword sqlFunction sp_remote_primary_keys 300syn keyword sqlFunction sp_remote_procedures 301syn keyword sqlFunction sp_remote_tables 302syn keyword sqlFunction sp_remoteoption 303syn keyword sqlFunction sp_rename 304syn keyword sqlFunction sp_renamedb 305syn keyword sqlFunction sp_reportstats 306syn keyword sqlFunction sp_reset_tsql_environment 307syn keyword sqlFunction sp_role 308syn keyword sqlFunction sp_server_info 309syn keyword sqlFunction sp_servercaps 310syn keyword sqlFunction sp_serverinfo 311syn keyword sqlFunction sp_serveroption 312syn keyword sqlFunction sp_setlangalias 313syn keyword sqlFunction sp_setreplicate 314syn keyword sqlFunction sp_setrepproc 315syn keyword sqlFunction sp_setreptable 316syn keyword sqlFunction sp_spaceused 317syn keyword sqlFunction sp_special_columns 318syn keyword sqlFunction sp_sproc_columns 319syn keyword sqlFunction sp_statistics 320syn keyword sqlFunction sp_stored_procedures 321syn keyword sqlFunction sp_syntax 322syn keyword sqlFunction sp_table_privileges 323syn keyword sqlFunction sp_tables 324syn keyword sqlFunction sp_tsql_environment 325syn keyword sqlFunction sp_tsql_feature_not_supported 326syn keyword sqlFunction sp_unbindefault 327syn keyword sqlFunction sp_unbindmsg 328syn keyword sqlFunction sp_unbindrule 329syn keyword sqlFunction sp_volchanged 330syn keyword sqlFunction sp_who 331syn keyword sqlFunction xp_scanf 332syn keyword sqlFunction xp_sprintf 333 334" server functions 335syn keyword sqlFunction col_length 336syn keyword sqlFunction col_name 337syn keyword sqlFunction index_col 338syn keyword sqlFunction object_id 339syn keyword sqlFunction object_name 340syn keyword sqlFunction proc_role 341syn keyword sqlFunction show_role 342syn keyword sqlFunction xp_cmdshell 343syn keyword sqlFunction xp_msver 344syn keyword sqlFunction xp_read_file 345syn keyword sqlFunction xp_real_cmdshell 346syn keyword sqlFunction xp_real_read_file 347syn keyword sqlFunction xp_real_sendmail 348syn keyword sqlFunction xp_real_startmail 349syn keyword sqlFunction xp_real_startsmtp 350syn keyword sqlFunction xp_real_stopmail 351syn keyword sqlFunction xp_real_stopsmtp 352syn keyword sqlFunction xp_real_write_file 353syn keyword sqlFunction xp_scanf 354syn keyword sqlFunction xp_sendmail 355syn keyword sqlFunction xp_sprintf 356syn keyword sqlFunction xp_startmail 357syn keyword sqlFunction xp_startsmtp 358syn keyword sqlFunction xp_stopmail 359syn keyword sqlFunction xp_stopsmtp 360syn keyword sqlFunction xp_write_file 361 362" http functions 363syn keyword sqlFunction http_header http_variable 364syn keyword sqlFunction next_http_header next_http_response_header next_http_variable 365syn keyword sqlFunction sa_set_http_header sa_set_http_option 366syn keyword sqlFunction sa_http_variable_info sa_http_header_info 367 368" http functions 9.0.1 369syn keyword sqlFunction http_encode http_decode 370syn keyword sqlFunction html_encode html_decode 371 372" XML function support 373syn keyword sqlFunction openxml xmlelement xmlforest xmlgen xmlconcat xmlagg 374syn keyword sqlFunction xmlattributes 375 376" Spatial Compatibility Functions 377syn keyword sqlFunction ST_BdMPolyFromText 378syn keyword sqlFunction ST_BdMPolyFromWKB 379syn keyword sqlFunction ST_BdPolyFromText 380syn keyword sqlFunction ST_BdPolyFromWKB 381syn keyword sqlFunction ST_CPolyFromText 382syn keyword sqlFunction ST_CPolyFromWKB 383syn keyword sqlFunction ST_CircularFromTxt 384syn keyword sqlFunction ST_CircularFromWKB 385syn keyword sqlFunction ST_CompoundFromTxt 386syn keyword sqlFunction ST_CompoundFromWKB 387syn keyword sqlFunction ST_GeomCollFromTxt 388syn keyword sqlFunction ST_GeomCollFromWKB 389syn keyword sqlFunction ST_GeomFromText 390syn keyword sqlFunction ST_GeomFromWKB 391syn keyword sqlFunction ST_LineFromText 392syn keyword sqlFunction ST_LineFromWKB 393syn keyword sqlFunction ST_MCurveFromText 394syn keyword sqlFunction ST_MCurveFromWKB 395syn keyword sqlFunction ST_MLineFromText 396syn keyword sqlFunction ST_MLineFromWKB 397syn keyword sqlFunction ST_MPointFromText 398syn keyword sqlFunction ST_MPointFromWKB 399syn keyword sqlFunction ST_MPolyFromText 400syn keyword sqlFunction ST_MPolyFromWKB 401syn keyword sqlFunction ST_MSurfaceFromTxt 402syn keyword sqlFunction ST_MSurfaceFromWKB 403syn keyword sqlFunction ST_OrderingEquals 404syn keyword sqlFunction ST_PointFromText 405syn keyword sqlFunction ST_PointFromWKB 406syn keyword sqlFunction ST_PolyFromText 407syn keyword sqlFunction ST_PolyFromWKB 408" Spatial Structural Methods 409syn keyword sqlFunction ST_CoordDim 410syn keyword sqlFunction ST_CurveN 411syn keyword sqlFunction ST_Dimension 412syn keyword sqlFunction ST_EndPoint 413syn keyword sqlFunction ST_ExteriorRing 414syn keyword sqlFunction ST_GeometryN 415syn keyword sqlFunction ST_GeometryType 416syn keyword sqlFunction ST_InteriorRingN 417syn keyword sqlFunction ST_Is3D 418syn keyword sqlFunction ST_IsClosed 419syn keyword sqlFunction ST_IsEmpty 420syn keyword sqlFunction ST_IsMeasured 421syn keyword sqlFunction ST_IsRing 422syn keyword sqlFunction ST_IsSimple 423syn keyword sqlFunction ST_IsValid 424syn keyword sqlFunction ST_NumCurves 425syn keyword sqlFunction ST_NumGeometries 426syn keyword sqlFunction ST_NumInteriorRing 427syn keyword sqlFunction ST_NumPoints 428syn keyword sqlFunction ST_PointN 429syn keyword sqlFunction ST_StartPoint 430"Spatial Computation 431syn keyword sqlFunction ST_Length 432syn keyword sqlFunction ST_Area 433syn keyword sqlFunction ST_Centroid 434syn keyword sqlFunction ST_Area 435syn keyword sqlFunction ST_Centroid 436syn keyword sqlFunction ST_IsWorld 437syn keyword sqlFunction ST_Perimeter 438syn keyword sqlFunction ST_PointOnSurface 439syn keyword sqlFunction ST_Distance 440" Spatial Input/Output 441syn keyword sqlFunction ST_AsBinary 442syn keyword sqlFunction ST_AsGML 443syn keyword sqlFunction ST_AsGeoJSON 444syn keyword sqlFunction ST_AsSVG 445syn keyword sqlFunction ST_AsSVGAggr 446syn keyword sqlFunction ST_AsText 447syn keyword sqlFunction ST_AsWKB 448syn keyword sqlFunction ST_AsWKT 449syn keyword sqlFunction ST_AsXML 450syn keyword sqlFunction ST_GeomFromBinary 451syn keyword sqlFunction ST_GeomFromShape 452syn keyword sqlFunction ST_GeomFromText 453syn keyword sqlFunction ST_GeomFromWKB 454syn keyword sqlFunction ST_GeomFromWKT 455syn keyword sqlFunction ST_GeomFromXML 456" Spatial Cast Methods 457syn keyword sqlFunction ST_CurvePolyToPoly 458syn keyword sqlFunction ST_CurveToLine 459syn keyword sqlFunction ST_ToCircular 460syn keyword sqlFunction ST_ToCompound 461syn keyword sqlFunction ST_ToCurve 462syn keyword sqlFunction ST_ToCurvePoly 463syn keyword sqlFunction ST_ToGeomColl 464syn keyword sqlFunction ST_ToLineString 465syn keyword sqlFunction ST_ToMultiCurve 466syn keyword sqlFunction ST_ToMultiLine 467syn keyword sqlFunction ST_ToMultiPoint 468syn keyword sqlFunction ST_ToMultiPolygon 469syn keyword sqlFunction ST_ToMultiSurface 470syn keyword sqlFunction ST_ToPoint 471syn keyword sqlFunction ST_ToPolygon 472syn keyword sqlFunction ST_ToSurface 473 474" Array functions 16.x 475syn keyword sqlFunction array array_agg array_max_cardinality trim_array 476syn keyword sqlFunction error_line error_message error_procedure 477syn keyword sqlFunction error_sqlcode error_sqlstate error_stack_trace 478 479 480" keywords 481syn keyword sqlKeyword absolute accent access account action active activate add address admin 482syn keyword sqlKeyword aes_decrypt after aggregate algorithm allow_dup_row allow allowed alter 483syn keyword sqlKeyword always and angular ansi_substring any as append apply 484syn keyword sqlKeyword arbiter array asc ascii ase 485syn keyword sqlKeyword assign at atan2 atomic attended 486syn keyword sqlKeyword audit auditing authentication authorization axis 487syn keyword sqlKeyword autoincrement autostop batch bcp before 488syn keyword sqlKeyword between bit_and bit_length bit_or bit_substr bit_xor 489syn keyword sqlKeyword blank blanks block 490syn keyword sqlKeyword both bottom unbounded breaker bufferpool 491syn keyword sqlKeyword build bulk by byte bytes cache calibrate calibration 492syn keyword sqlKeyword cancel capability cardinality cascade cast 493syn keyword sqlKeyword catalog catch ceil change changes char char_convert 494syn keyword sqlKeyword check checkpointlog checksum class classes client cmp 495syn keyword sqlKeyword cluster clustered collation 496syn keyword sqlKeyword column columns 497syn keyword sqlKeyword command comments committed commitid comparisons 498syn keyword sqlKeyword compatible component compressed compute computes 499syn keyword sqlKeyword concat configuration confirm conflict connection 500syn keyword sqlKeyword console consolidate consolidated 501syn keyword sqlKeyword constraint constraints content 502syn keyword sqlKeyword convert coordinate coordinator copy count count_set_bits 503syn keyword sqlKeyword crc createtime critical cross cube cume_dist 504syn keyword sqlKeyword current cursor data data database 505syn keyword sqlKeyword current_timestamp current_user cycle 506syn keyword sqlKeyword databases datatype dba dbfile 507syn keyword sqlKeyword dbspace dbspaces dbspacename debug decoupled 508syn keyword sqlKeyword decrypted default defaults default_dbspace deferred 509syn keyword sqlKeyword definer definition 510syn keyword sqlKeyword delay deleting delimited dependencies desc 511syn keyword sqlKeyword description deterministic directory 512syn keyword sqlKeyword disable disabled disallow distinct disksandbox disk_sandbox 513syn keyword sqlKeyword dn do domain download duplicate 514syn keyword sqlKeyword dsetpass dttm dynamic each earth editproc effective ejb 515syn keyword sqlKeyword elimination ellipsoid else elseif 516syn keyword sqlKeyword email empty enable encapsulated encrypted encryption end 517syn keyword sqlKeyword encoding endif engine environment erase error errors escape escapes event 518syn keyword sqlKeyword event_parameter every exception exclude excluded exclusive exec 519syn keyword sqlKeyword existing exists expanded expiry express exprtype extended_property 520syn keyword sqlKeyword external externlogin factor failover false 521syn keyword sqlKeyword fastfirstrow feature fieldproc file files filler 522syn keyword sqlKeyword fillfactor final finish first first_keyword first_value 523syn keyword sqlKeyword flattening 524syn keyword sqlKeyword following force foreign format forjson forxml forxml_sep fp frame 525syn keyword sqlKeyword free freepage french fresh full function 526syn keyword sqlKeyword gb generic get_bit go global grid 527syn keyword sqlKeyword group handler hash having header hexadecimal 528syn keyword sqlKeyword hidden high history hg hng hold holdlock host 529syn keyword sqlKeyword hours http_body http_session_timeout id identified identity ignore 530syn keyword sqlKeyword ignore_dup_key ignore_dup_row immediate 531syn keyword sqlKeyword in inactiv inactive inactivity included increment incremental 532syn keyword sqlKeyword index index_enabled index_lparen indexonly info information 533syn keyword sqlKeyword inheritance inline inner inout insensitive inserting 534syn keyword sqlKeyword instead 535syn keyword sqlKeyword internal intersection into introduced inverse invoker 536syn keyword sqlKeyword iq is isolation 537syn keyword sqlKeyword jar java java_location java_main_userid java_vm_options 538syn keyword sqlKeyword jconnect jdk join json kb key keys keep language last 539syn keyword sqlKeyword last_keyword last_value lateral latitude 540syn keyword sqlKeyword ld ldap left len linear lf ln level like 541syn keyword sqlKeyword limit local location log 542syn keyword sqlKeyword logging logical login logscan long longitude low lru ls 543syn keyword sqlKeyword main major manage manual mark master 544syn keyword sqlKeyword match matched materialized max maxvalue maximum mb measure median membership 545syn keyword sqlKeyword merge metadata methods migrate minimum minor minutes minvalue mirror 546syn keyword sqlKeyword mode modify monitor move mru multiplex 547syn keyword sqlKeyword name named namespaces national native natural new next nextval 548syn keyword sqlKeyword ngram no noholdlock nolock nonclustered none normal not 549syn keyword sqlKeyword notify null nullable_constant nulls 550syn keyword sqlKeyword object objects oem_string of off offline offset olap 551syn keyword sqlKeyword old on online only openstring operator 552syn keyword sqlKeyword optimization optimizer option 553syn keyword sqlKeyword or order ordinality organization others out outer over owner 554syn keyword sqlKeyword package packetsize padding page pages 555syn keyword sqlKeyword paglock parallel parameter parent part partial 556syn keyword sqlKeyword partition partitions partner password path pctfree 557syn keyword sqlKeyword permissions perms plan planar policy polygon populate port postfilter preceding 558syn keyword sqlKeyword precisionprefetch prefilter prefix preserve preview previous 559syn keyword sqlKeyword primary prior priority priqty private privilege privileges procedure profile profiling 560syn keyword sqlKeyword property_is_cumulative property_is_numeric public publication publish publisher 561syn keyword sqlKeyword quiesce quote quotes range readclientfile readcommitted reader readfile readonly 562syn keyword sqlKeyword readpast readuncommitted readwrite rebuild 563syn keyword sqlKeyword received recompile recover recursive references 564syn keyword sqlKeyword referencing regex regexp regexp_substr relative relocate 565syn keyword sqlKeyword rename repeatable repeatableread replicate replication 566syn keyword sqlKeyword requests request_timeout required rereceive resend reserve reset 567syn keyword sqlKeyword resizing resolve resource respect restart 568syn keyword sqlKeyword restrict result retain retries 569syn keyword sqlKeyword returns reverse right role roles 570syn keyword sqlKeyword rollup root row row_number rowlock rows rowtype 571syn keyword sqlKeyword sa_index_hash sa_internal_fk_verify sa_internal_termbreak 572syn keyword sqlKeyword sa_order_preserving_hash sa_order_preserving_hash_big sa_order_preserving_hash_prefix 573syn keyword sqlKeyword sa_file_free_pages sa_internal_type_from_catalog sa_internal_valid_hash 574syn keyword sqlKeyword sa_internal_validate_value sa_json_element 575syn keyword sqlKeyword scale schedule schema scope script scripted scroll search seconds secqty security 576syn keyword sqlKeyword semi send sensitive sent sequence serializable 577syn keyword sqlKeyword server severity session set_bit set_bits sets 578syn keyword sqlKeyword shapefile share side simple since site size skip 579syn keyword sqlKeyword snap snapshot soapheader soap_header 580syn keyword sqlKeyword spatial split some sorted_data 581syn keyword sqlKeyword sql sqlcode sqlid sqlflagger sqlstate sqrt square 582syn keyword sqlKeyword stacker stale state statement statistics status stddev_pop stddev_samp 583syn keyword sqlKeyword stemmer stogroup stoplist storage store 584syn keyword sqlKeyword strip stripesizekb striping subpages subscribe subscription 585syn keyword sqlKeyword subtransaction suser_id suser_name suspend synchronization 586syn keyword sqlKeyword syntax_error table tables tablock 587syn keyword sqlKeyword tablockx target tb temp template temporary term then ties 588syn keyword sqlKeyword timezone timeout tls to to_char to_nchar tolerance top 589syn keyword sqlKeyword trace traced_plan tracing 590syn keyword sqlKeyword transfer transform transaction transactional treat tries 591syn keyword sqlKeyword true try tsequal type tune uncommitted unconditionally 592syn keyword sqlKeyword unenforced unicode unique unistr unit unknown unlimited unload 593syn keyword sqlKeyword unpartition unquiesce updatetime updating updlock upgrade upload 594syn keyword sqlKeyword upper usage use user 595syn keyword sqlKeyword using utc utilities validproc 596syn keyword sqlKeyword value values varchar variable 597syn keyword sqlKeyword varying var_pop var_samp vcat verbosity 598syn keyword sqlKeyword verify versions view virtual wait 599syn keyword sqlKeyword warning wd web when where with with_auto 600syn keyword sqlKeyword with_auto with_cube with_rollup without 601syn keyword sqlKeyword with_lparen within word work workload write writefile 602syn keyword sqlKeyword writeclientfile writer writers writeserver xlock 603syn keyword sqlKeyword war xml zeros zone 604" XML 605syn keyword sqlKeyword raw auto elements explicit 606" HTTP support 607syn keyword sqlKeyword authorization secure url service next_soap_header 608" HTTP 9.0.2 new procedure keywords 609syn keyword sqlKeyword namespace certificate certificates clientport proxy trusted_certificates_file 610" OLAP support 9.0.0 611syn keyword sqlKeyword covar_pop covar_samp corr regr_slope regr_intercept 612syn keyword sqlKeyword regr_count regr_r2 regr_avgx regr_avgy 613syn keyword sqlKeyword regr_sxx regr_syy regr_sxy 614 615" Alternate keywords 616syn keyword sqlKeyword character dec options proc reference 617syn keyword sqlKeyword subtrans tran syn keyword 618 619" Login Mode Options 620syn keyword sqlKeywordLogin standard integrated kerberos LDAPUA 621syn keyword sqlKeywordLogin cloudadmin mixed 622 623" Spatial Predicates 624syn keyword sqlKeyword ST_Contains 625syn keyword sqlKeyword ST_ContainsFilter 626syn keyword sqlKeyword ST_CoveredBy 627syn keyword sqlKeyword ST_CoveredByFilter 628syn keyword sqlKeyword ST_Covers 629syn keyword sqlKeyword ST_CoversFilter 630syn keyword sqlKeyword ST_Crosses 631syn keyword sqlKeyword ST_Disjoint 632syn keyword sqlKeyword ST_Equals 633syn keyword sqlKeyword ST_EqualsFilter 634syn keyword sqlKeyword ST_Intersects 635syn keyword sqlKeyword ST_IntersectsFilter 636syn keyword sqlKeyword ST_IntersectsRect 637syn keyword sqlKeyword ST_OrderingEquals 638syn keyword sqlKeyword ST_Overlaps 639syn keyword sqlKeyword ST_Relate 640syn keyword sqlKeyword ST_Touches 641syn keyword sqlKeyword ST_Within 642syn keyword sqlKeyword ST_WithinFilter 643" Spatial Set operations 644syn keyword sqlKeyword ST_Affine 645syn keyword sqlKeyword ST_Boundary 646syn keyword sqlKeyword ST_Buffer 647syn keyword sqlKeyword ST_ConvexHull 648syn keyword sqlKeyword ST_ConvexHullAggr 649syn keyword sqlKeyword ST_Difference 650syn keyword sqlKeyword ST_Intersection 651syn keyword sqlKeyword ST_IntersectionAggr 652syn keyword sqlKeyword ST_SymDifference 653syn keyword sqlKeyword ST_Union 654syn keyword sqlKeyword ST_UnionAggr 655" Spatial Bounds 656syn keyword sqlKeyword ST_Envelope 657syn keyword sqlKeyword ST_EnvelopeAggr 658syn keyword sqlKeyword ST_Lat 659syn keyword sqlKeyword ST_LatMax 660syn keyword sqlKeyword ST_LatMin 661syn keyword sqlKeyword ST_Long 662syn keyword sqlKeyword ST_LongMax 663syn keyword sqlKeyword ST_LongMin 664syn keyword sqlKeyword ST_M 665syn keyword sqlKeyword ST_MMax 666syn keyword sqlKeyword ST_MMin 667syn keyword sqlKeyword ST_Point 668syn keyword sqlKeyword ST_X 669syn keyword sqlKeyword ST_XMax 670syn keyword sqlKeyword ST_XMin 671syn keyword sqlKeyword ST_Y 672syn keyword sqlKeyword ST_YMax 673syn keyword sqlKeyword ST_YMin 674syn keyword sqlKeyword ST_Z 675syn keyword sqlKeyword ST_ZMax 676syn keyword sqlKeyword ST_ZMin 677" Spatial Collection Aggregates 678syn keyword sqlKeyword ST_GeomCollectionAggr 679syn keyword sqlKeyword ST_LineStringAggr 680syn keyword sqlKeyword ST_MultiCurveAggr 681syn keyword sqlKeyword ST_MultiLineStringAggr 682syn keyword sqlKeyword ST_MultiPointAggr 683syn keyword sqlKeyword ST_MultiPolygonAggr 684syn keyword sqlKeyword ST_MultiSurfaceAggr 685syn keyword sqlKeyword ST_Perimeter 686syn keyword sqlKeyword ST_PointOnSurface 687" Spatial SRS 688syn keyword sqlKeyword ST_CompareWKT 689syn keyword sqlKeyword ST_FormatWKT 690syn keyword sqlKeyword ST_ParseWKT 691syn keyword sqlKeyword ST_TransformGeom 692syn keyword sqlKeyword ST_GeometryTypeFromBaseType 693syn keyword sqlKeyword ST_SnapToGrid 694syn keyword sqlKeyword ST_Transform 695syn keyword sqlKeyword ST_SRID 696syn keyword sqlKeyword ST_SRIDFromBaseType 697syn keyword sqlKeyword ST_LoadConfigurationData 698" Spatial Indexes 699syn keyword sqlKeyword ST_LinearHash 700syn keyword sqlKeyword ST_LinearUnHash 701 702syn keyword sqlOperator in any some all between exists 703syn keyword sqlOperator like escape not is and or 704syn keyword sqlOperator minus 705syn keyword sqlOperator prior distinct unnest 706 707syn keyword sqlStatement allocate alter attach backup begin break call case catch 708syn keyword sqlStatement checkpoint clear close comment commit configure connect 709syn keyword sqlStatement continue create deallocate declare delete describe 710syn keyword sqlStatement detach disconnect drop except execute exit explain fetch 711syn keyword sqlStatement for forward from get goto grant help if include 712syn keyword sqlStatement input insert install intersect leave load lock loop 713syn keyword sqlStatement message open output parameters passthrough 714syn keyword sqlStatement prepare print put raiserror read readtext refresh release 715syn keyword sqlStatement remote remove reorganize resignal restore resume 716syn keyword sqlStatement return revoke rollback save savepoint select 717syn keyword sqlStatement set setuser signal start stop synchronize 718syn keyword sqlStatement system trigger truncate try union unload update 719syn keyword sqlStatement validate waitfor whenever while window writetext 720 721 722syn keyword sqlType char nchar long varchar nvarchar text ntext uniqueidentifierstr xml 723syn keyword sqlType bigint bit decimal double varbit 724syn keyword sqlType float int integer numeric 725syn keyword sqlType smallint tinyint real 726syn keyword sqlType money smallmoney 727syn keyword sqlType date datetime datetimeoffset smalldatetime time timestamp 728syn keyword sqlType binary image varray varbinary uniqueidentifier 729syn keyword sqlType unsigned 730" Spatial types 731syn keyword sqlType st_geometry st_point st_curve st_surface st_geomcollection 732syn keyword sqlType st_linestring st_circularstring st_compoundcurve 733syn keyword sqlType st_curvepolygon st_polygon 734syn keyword sqlType st_multipoint st_multicurve st_multisurface 735syn keyword sqlType st_multilinestring st_multipolygon 736 737syn keyword sqlOption Allow_nulls_by_default 738syn keyword sqlOption Allow_read_client_file 739syn keyword sqlOption Allow_snapshot_isolation 740syn keyword sqlOption Allow_write_client_file 741syn keyword sqlOption Ansi_blanks 742syn keyword sqlOption Ansi_close_cursors_on_rollback 743syn keyword sqlOption Ansi_permissions 744syn keyword sqlOption Ansi_substring 745syn keyword sqlOption Ansi_update_constraints 746syn keyword sqlOption Ansinull 747syn keyword sqlOption Auditing 748syn keyword sqlOption Auditing_options 749syn keyword sqlOption Auto_commit_on_create_local_temp_index 750syn keyword sqlOption Background_priority 751syn keyword sqlOption Blocking 752syn keyword sqlOption Blocking_others_timeout 753syn keyword sqlOption Blocking_timeout 754syn keyword sqlOption Chained 755syn keyword sqlOption Checkpoint_time 756syn keyword sqlOption Cis_option 757syn keyword sqlOption Cis_rowset_size 758syn keyword sqlOption Close_on_endtrans 759syn keyword sqlOption Collect_statistics_on_dml_updates 760syn keyword sqlOption Conn_auditing 761syn keyword sqlOption Connection_authentication 762syn keyword sqlOption Continue_after_raiserror 763syn keyword sqlOption Conversion_error 764syn keyword sqlOption Cooperative_commit_timeout 765syn keyword sqlOption Cooperative_commits 766syn keyword sqlOption Database_authentication 767syn keyword sqlOption Date_format 768syn keyword sqlOption Date_order 769syn keyword sqlOption db_publisher 770syn keyword sqlOption Debug_messages 771syn keyword sqlOption Dedicated_task 772syn keyword sqlOption Default_dbspace 773syn keyword sqlOption Default_timestamp_increment 774syn keyword sqlOption Delayed_commit_timeout 775syn keyword sqlOption Delayed_commits 776syn keyword sqlOption Divide_by_zero_error 777syn keyword sqlOption Escape_character 778syn keyword sqlOption Exclude_operators 779syn keyword sqlOption Extended_join_syntax 780syn keyword sqlOption Extern_login_credentials 781syn keyword sqlOption Fire_triggers 782syn keyword sqlOption First_day_of_week 783syn keyword sqlOption For_xml_null_treatment 784syn keyword sqlOption Force_view_creation 785syn keyword sqlOption Global_database_id 786syn keyword sqlOption Http_session_timeout 787syn keyword sqlOption Http_connection_pool_basesize 788syn keyword sqlOption Http_connection_pool_timeout 789syn keyword sqlOption Integrated_server_name 790syn keyword sqlOption Isolation_level 791syn keyword sqlOption Java_class_path 792syn keyword sqlOption Java_location 793syn keyword sqlOption Java_main_userid 794syn keyword sqlOption Java_vm_options 795syn keyword sqlOption Lock_rejected_rows 796syn keyword sqlOption Log_deadlocks 797syn keyword sqlOption Login_mode 798syn keyword sqlOption Login_procedure 799syn keyword sqlOption Materialized_view_optimization 800syn keyword sqlOption Max_client_statements_cached 801syn keyword sqlOption Max_cursor_count 802syn keyword sqlOption Max_hash_size 803syn keyword sqlOption Max_plans_cached 804syn keyword sqlOption Max_priority 805syn keyword sqlOption Max_query_tasks 806syn keyword sqlOption Max_recursive_iterations 807syn keyword sqlOption Max_statement_count 808syn keyword sqlOption Max_temp_space 809syn keyword sqlOption Min_password_length 810syn keyword sqlOption Min_role_admins 811syn keyword sqlOption Nearest_century 812syn keyword sqlOption Non_keywords 813syn keyword sqlOption Odbc_describe_binary_as_varbinary 814syn keyword sqlOption Odbc_distinguish_char_and_varchar 815syn keyword sqlOption Oem_string 816syn keyword sqlOption On_charset_conversion_failure 817syn keyword sqlOption On_tsql_error 818syn keyword sqlOption Optimization_goal 819syn keyword sqlOption Optimization_level 820syn keyword sqlOption Optimization_workload 821syn keyword sqlOption Pinned_cursor_percent_of_cache 822syn keyword sqlOption Post_login_procedure 823syn keyword sqlOption Precision 824syn keyword sqlOption Prefetch 825syn keyword sqlOption Preserve_source_format 826syn keyword sqlOption Prevent_article_pkey_update 827syn keyword sqlOption Priority 828syn keyword sqlOption Progress_messages 829syn keyword sqlOption Query_mem_timeout 830syn keyword sqlOption Quoted_identifier 831syn keyword sqlOption Read_past_deleted 832syn keyword sqlOption Recovery_time 833syn keyword sqlOption Remote_idle_timeout 834syn keyword sqlOption Replicate_all 835syn keyword sqlOption Request_timeout 836syn keyword sqlOption Reserved_keywords 837syn keyword sqlOption Return_date_time_as_string 838syn keyword sqlOption Rollback_on_deadlock 839syn keyword sqlOption Row_counts 840syn keyword sqlOption Scale 841syn keyword sqlOption Secure_feature_key 842syn keyword sqlOption Sort_collation 843syn keyword sqlOption Sql_flagger_error_level 844syn keyword sqlOption Sql_flagger_warning_level 845syn keyword sqlOption String_rtruncation 846syn keyword sqlOption st_geometry_asbinary_format 847syn keyword sqlOption st_geometry_astext_format 848syn keyword sqlOption st_geometry_asxml_format 849syn keyword sqlOption st_geometry_describe_type 850syn keyword sqlOption st_geometry_interpolation 851syn keyword sqlOption st_geometry_on_invalid 852syn keyword sqlOption Subsume_row_locks 853syn keyword sqlOption Suppress_tds_debugging 854syn keyword sqlOption Synchronize_mirror_on_commit 855syn keyword sqlOption Tds_empty_string_is_null 856syn keyword sqlOption Temp_space_limit_check 857syn keyword sqlOption Time_format 858syn keyword sqlOption Time_zone_adjustment 859syn keyword sqlOption Timestamp_format 860syn keyword sqlOption Timestamp_with_time_zone_format 861syn keyword sqlOption Truncate_timestamp_values 862syn keyword sqlOption Tsql_outer_joins 863syn keyword sqlOption Tsql_variables 864syn keyword sqlOption Updatable_statement_isolation 865syn keyword sqlOption Update_statistics 866syn keyword sqlOption Upgrade_database_capability 867syn keyword sqlOption User_estimates 868syn keyword sqlOption Uuid_has_hyphens 869syn keyword sqlOption Verify_password_function 870syn keyword sqlOption Wait_for_commit 871syn keyword sqlOption Webservice_namespace_host 872syn keyword sqlOption Webservice_sessionid_name 873 874" Strings and characters: 875syn region sqlString start=+"+ end=+"+ contains=@Spell 876syn region sqlString start=+'+ end=+'+ contains=@Spell 877 878" Numbers: 879syn match sqlNumber "-\=\<\d*\.\=[0-9_]\>" 880 881" Comments: 882syn region sqlDashComment start=/--/ end=/$/ contains=@Spell 883syn region sqlSlashComment start=/\/\// end=/$/ contains=@Spell 884syn region sqlMultiComment start="/\*" end="\*/" contains=sqlMultiComment,@Spell 885syn cluster sqlComment contains=sqlDashComment,sqlSlashComment,sqlMultiComment,@Spell 886syn sync ccomment sqlComment 887syn sync ccomment sqlDashComment 888syn sync ccomment sqlSlashComment 889 890hi def link sqlDashComment Comment 891hi def link sqlSlashComment Comment 892hi def link sqlMultiComment Comment 893hi def link sqlNumber Number 894hi def link sqlOperator Operator 895hi def link sqlSpecial Special 896hi def link sqlKeyword Keyword 897hi def link sqlStatement Statement 898hi def link sqlString String 899hi def link sqlType Type 900hi def link sqlFunction Function 901hi def link sqlOption PreProc 902 903let b:current_syntax = "sqlanywhere" 904 905" vim:sw=4: 906