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