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