" Vim syntax file " Language: SQL, Adaptive Server Anywhere " Maintainer: David Fishburn " Last Change: Thu Sep 15 2005 10:30:09 AM " Version: 9.0.2 " Description: Updated to Adaptive Server Anywhere 9.0.2 " Updated to Adaptive Server Anywhere 9.0.1 " Updated to Adaptive Server Anywhere 9.0.0 " " For version 5.x: Clear all syntax items " For version 6.x: Quit when a syntax file was already loaded if version < 600 syntax clear elseif exists("b:current_syntax") finish endif syn case ignore " The SQL reserved words, defined as keywords. syn keyword sqlSpecial false null true " common functions syn keyword sqlFunction count sum avg min max debug_eng isnull syn keyword sqlFunction greater lesser argn string ymd todate syn keyword sqlFunction totimestamp date today now utc_now syn keyword sqlFunction number identity years months weeks days syn keyword sqlFunction hours minutes seconds second minute hour syn keyword sqlFunction day month year dow date_format substr syn keyword sqlFunction substring byte_substr length byte_length syn keyword sqlFunction datalength ifnull evaluate list syn keyword sqlFunction soundex similar difference like_start syn keyword sqlFunction like_end regexp_compile syn keyword sqlFunction regexp_compile_patindex remainder abs syn keyword sqlFunction graphical_plan plan explanation ulplan syn keyword sqlFunction graphical_ulplan long_ulplan syn keyword sqlFunction short_ulplan rewrite watcomsql syn keyword sqlFunction transactsql dialect estimate syn keyword sqlFunction estimate_source index_estimate syn keyword sqlFunction experience_estimate traceback wsql_state syn keyword sqlFunction lang_message dateadd datediff datepart syn keyword sqlFunction datename dayname monthname quarter syn keyword sqlFunction tsequal hextoint inttohex rand textptr syn keyword sqlFunction rowid grouping stddev variance rank syn keyword sqlFunction dense_rank density percent_rank user_name syn keyword sqlFunction user_id str stuff char_length nullif syn keyword sqlFunction sortkey compare ts_index_statistics syn keyword sqlFunction ts_table_statistics isdate isnumeric syn keyword sqlFunction get_identity lookup newid uuidtostr syn keyword sqlFunction strtouuid varexists " 9.0.1 functions syn keyword sqlFunction acos asin atan atn2 cast ceiling convert cos cot syn keyword sqlFunction char_length coalesce dateformat datetime degrees exp syn keyword sqlFunction floor getdate insertstr syn keyword sqlFunction log log10 lower mod pi power syn keyword sqlFunction property radians replicate round sign sin syn keyword sqlFunction sqldialect tan truncate truncnum syn keyword sqlFunction base64_encode base64_decode syn keyword sqlFunction hash compress decompress encrypt decrypt " string functions syn keyword sqlFunction ascii char left ltrim repeat syn keyword sqlFunction space right rtrim trim lcase ucase syn keyword sqlFunction locate charindex patindex replace syn keyword sqlFunction errormsg csconvert " property functions syn keyword sqlFunction db_id db_name property_name syn keyword sqlFunction property_description property_number syn keyword sqlFunction next_connection next_database property syn keyword sqlFunction connection_property db_property db_extended_property syn keyword sqlFunction event_parmeter event_condition event_condition_name " sa_ procedures syn keyword sqlFunction sa_add_index_consultant_analysis syn keyword sqlFunction sa_add_workload_query syn keyword sqlFunction sa_app_deregister syn keyword sqlFunction sa_app_get_infoStr syn keyword sqlFunction sa_app_get_status syn keyword sqlFunction sa_app_register syn keyword sqlFunction sa_app_registration_unlock syn keyword sqlFunction sa_app_set_infoStr syn keyword sqlFunction sa_audit_string syn keyword sqlFunction sa_check_commit syn keyword sqlFunction sa_checkpoint_execute syn keyword sqlFunction sa_conn_activity syn keyword sqlFunction sa_conn_compression_info syn keyword sqlFunction sa_conn_deregister syn keyword sqlFunction sa_conn_info syn keyword sqlFunction sa_conn_properties syn keyword sqlFunction sa_conn_properties_by_conn syn keyword sqlFunction sa_conn_properties_by_name syn keyword sqlFunction sa_conn_register syn keyword sqlFunction sa_conn_set_status syn keyword sqlFunction sa_create_analysis_from_query syn keyword sqlFunction sa_db_info syn keyword sqlFunction sa_db_properties syn keyword sqlFunction sa_disable_auditing_type syn keyword sqlFunction sa_disable_index syn keyword sqlFunction sa_disk_free_space syn keyword sqlFunction sa_enable_auditing_type syn keyword sqlFunction sa_enable_index syn keyword sqlFunction sa_end_forward_to syn keyword sqlFunction sa_eng_properties syn keyword sqlFunction sa_event_schedules syn keyword sqlFunction sa_exec_script syn keyword sqlFunction sa_flush_cache syn keyword sqlFunction sa_flush_statistics syn keyword sqlFunction sa_forward_to syn keyword sqlFunction sa_get_dtt syn keyword sqlFunction sa_get_histogram syn keyword sqlFunction sa_get_request_profile syn keyword sqlFunction sa_get_request_profile_sub syn keyword sqlFunction sa_get_request_times syn keyword sqlFunction sa_get_server_messages syn keyword sqlFunction sa_get_simulated_scale_factors syn keyword sqlFunction sa_get_workload_capture_status syn keyword sqlFunction sa_index_density syn keyword sqlFunction sa_index_levels syn keyword sqlFunction sa_index_statistics syn keyword sqlFunction sa_internal_alter_index_ability syn keyword sqlFunction sa_internal_create_analysis_from_query syn keyword sqlFunction sa_internal_disk_free_space syn keyword sqlFunction sa_internal_get_dtt syn keyword sqlFunction sa_internal_get_histogram syn keyword sqlFunction sa_internal_get_request_times syn keyword sqlFunction sa_internal_get_simulated_scale_factors syn keyword sqlFunction sa_internal_get_workload_capture_status syn keyword sqlFunction sa_internal_index_density syn keyword sqlFunction sa_internal_index_levels syn keyword sqlFunction sa_internal_index_statistics syn keyword sqlFunction sa_internal_java_loaded_classes syn keyword sqlFunction sa_internal_locks syn keyword sqlFunction sa_internal_pause_workload_capture syn keyword sqlFunction sa_internal_procedure_profile syn keyword sqlFunction sa_internal_procedure_profile_summary syn keyword sqlFunction sa_internal_read_backup_history syn keyword sqlFunction sa_internal_recommend_indexes syn keyword sqlFunction sa_internal_reset_identity syn keyword sqlFunction sa_internal_resume_workload_capture syn keyword sqlFunction sa_internal_start_workload_capture syn keyword sqlFunction sa_internal_stop_index_consultant syn keyword sqlFunction sa_internal_stop_workload_capture syn keyword sqlFunction sa_internal_table_fragmentation syn keyword sqlFunction sa_internal_table_page_usage syn keyword sqlFunction sa_internal_table_stats syn keyword sqlFunction sa_internal_virtual_sysindex syn keyword sqlFunction sa_internal_virtual_sysixcol syn keyword sqlFunction sa_java_loaded_classes syn keyword sqlFunction sa_jdk_version syn keyword sqlFunction sa_locks syn keyword sqlFunction sa_make_object syn keyword sqlFunction sa_pause_workload_capture syn keyword sqlFunction sa_proc_debug_attach_to_connection syn keyword sqlFunction sa_proc_debug_connect syn keyword sqlFunction sa_proc_debug_detach_from_connection syn keyword sqlFunction sa_proc_debug_disconnect syn keyword sqlFunction sa_proc_debug_get_connection_name syn keyword sqlFunction sa_proc_debug_release_connection syn keyword sqlFunction sa_proc_debug_request syn keyword sqlFunction sa_proc_debug_version syn keyword sqlFunction sa_proc_debug_wait_for_connection syn keyword sqlFunction sa_procedure_profile syn keyword sqlFunction sa_procedure_profile_summary syn keyword sqlFunction sa_read_backup_history syn keyword sqlFunction sa_recommend_indexes syn keyword sqlFunction sa_recompile_views syn keyword sqlFunction sa_remove_index_consultant_analysis syn keyword sqlFunction sa_remove_index_consultant_workload syn keyword sqlFunction sa_reset_identity syn keyword sqlFunction sa_resume_workload_capture syn keyword sqlFunction sa_server_option syn keyword sqlFunction sa_set_simulated_scale_factor syn keyword sqlFunction sa_setremoteuser syn keyword sqlFunction sa_setsubscription syn keyword sqlFunction sa_start_recording_commits syn keyword sqlFunction sa_start_workload_capture syn keyword sqlFunction sa_statement_text syn keyword sqlFunction sa_stop_index_consultant syn keyword sqlFunction sa_stop_recording_commits syn keyword sqlFunction sa_stop_workload_capture syn keyword sqlFunction sa_sync syn keyword sqlFunction sa_sync_sub syn keyword sqlFunction sa_table_fragmentation syn keyword sqlFunction sa_table_page_usage syn keyword sqlFunction sa_table_stats syn keyword sqlFunction sa_update_index_consultant_workload syn keyword sqlFunction sa_validate syn keyword sqlFunction sa_virtual_sysindex syn keyword sqlFunction sa_virtual_sysixcol " sp_ procedures syn keyword sqlFunction sp_addalias syn keyword sqlFunction sp_addauditrecord syn keyword sqlFunction sp_adddumpdevice syn keyword sqlFunction sp_addgroup syn keyword sqlFunction sp_addlanguage syn keyword sqlFunction sp_addlogin syn keyword sqlFunction sp_addmessage syn keyword sqlFunction sp_addremotelogin syn keyword sqlFunction sp_addsegment syn keyword sqlFunction sp_addserver syn keyword sqlFunction sp_addthreshold syn keyword sqlFunction sp_addtype syn keyword sqlFunction sp_adduser syn keyword sqlFunction sp_auditdatabase syn keyword sqlFunction sp_auditlogin syn keyword sqlFunction sp_auditobject syn keyword sqlFunction sp_auditoption syn keyword sqlFunction sp_auditsproc syn keyword sqlFunction sp_bindefault syn keyword sqlFunction sp_bindmsg syn keyword sqlFunction sp_bindrule syn keyword sqlFunction sp_changedbowner syn keyword sqlFunction sp_changegroup syn keyword sqlFunction sp_checknames syn keyword sqlFunction sp_checkperms syn keyword sqlFunction sp_checkreswords syn keyword sqlFunction sp_clearstats syn keyword sqlFunction sp_column_privileges syn keyword sqlFunction sp_columns syn keyword sqlFunction sp_commonkey syn keyword sqlFunction sp_configure syn keyword sqlFunction sp_cursorinfo syn keyword sqlFunction sp_databases syn keyword sqlFunction sp_datatype_info syn keyword sqlFunction sp_dboption syn keyword sqlFunction sp_dbremap syn keyword sqlFunction sp_depends syn keyword sqlFunction sp_diskdefault syn keyword sqlFunction sp_displaylogin syn keyword sqlFunction sp_dropalias syn keyword sqlFunction sp_dropdevice syn keyword sqlFunction sp_dropgroup syn keyword sqlFunction sp_dropkey syn keyword sqlFunction sp_droplanguage syn keyword sqlFunction sp_droplogin syn keyword sqlFunction sp_dropmessage syn keyword sqlFunction sp_dropremotelogin syn keyword sqlFunction sp_dropsegment syn keyword sqlFunction sp_dropserver syn keyword sqlFunction sp_dropthreshold syn keyword sqlFunction sp_droptype syn keyword sqlFunction sp_dropuser syn keyword sqlFunction sp_estspace syn keyword sqlFunction sp_extendsegment syn keyword sqlFunction sp_fkeys syn keyword sqlFunction sp_foreignkey syn keyword sqlFunction sp_getmessage syn keyword sqlFunction sp_help syn keyword sqlFunction sp_helpconstraint syn keyword sqlFunction sp_helpdb syn keyword sqlFunction sp_helpdevice syn keyword sqlFunction sp_helpgroup syn keyword sqlFunction sp_helpindex syn keyword sqlFunction sp_helpjoins syn keyword sqlFunction sp_helpkey syn keyword sqlFunction sp_helplanguage syn keyword sqlFunction sp_helplog syn keyword sqlFunction sp_helpprotect syn keyword sqlFunction sp_helpremotelogin syn keyword sqlFunction sp_helpsegment syn keyword sqlFunction sp_helpserver syn keyword sqlFunction sp_helpsort syn keyword sqlFunction sp_helptext syn keyword sqlFunction sp_helpthreshold syn keyword sqlFunction sp_helpuser syn keyword sqlFunction sp_indsuspect syn keyword sqlFunction sp_lock syn keyword sqlFunction sp_locklogin syn keyword sqlFunction sp_logdevice syn keyword sqlFunction sp_login_environment syn keyword sqlFunction sp_modifylogin syn keyword sqlFunction sp_modifythreshold syn keyword sqlFunction sp_monitor syn keyword sqlFunction sp_password syn keyword sqlFunction sp_pkeys syn keyword sqlFunction sp_placeobject syn keyword sqlFunction sp_primarykey syn keyword sqlFunction sp_procxmode syn keyword sqlFunction sp_recompile syn keyword sqlFunction sp_remap syn keyword sqlFunction sp_remote_columns syn keyword sqlFunction sp_remote_exported_keys syn keyword sqlFunction sp_remote_imported_keys syn keyword sqlFunction sp_remote_pcols syn keyword sqlFunction sp_remote_primary_keys syn keyword sqlFunction sp_remote_procedures syn keyword sqlFunction sp_remote_tables syn keyword sqlFunction sp_remoteoption syn keyword sqlFunction sp_rename syn keyword sqlFunction sp_renamedb syn keyword sqlFunction sp_reportstats syn keyword sqlFunction sp_reset_tsql_environment syn keyword sqlFunction sp_role syn keyword sqlFunction sp_server_info syn keyword sqlFunction sp_servercaps syn keyword sqlFunction sp_serverinfo syn keyword sqlFunction sp_serveroption syn keyword sqlFunction sp_setlangalias syn keyword sqlFunction sp_setreplicate syn keyword sqlFunction sp_setrepproc syn keyword sqlFunction sp_setreptable syn keyword sqlFunction sp_spaceused syn keyword sqlFunction sp_special_columns syn keyword sqlFunction sp_sproc_columns syn keyword sqlFunction sp_statistics syn keyword sqlFunction sp_stored_procedures syn keyword sqlFunction sp_syntax syn keyword sqlFunction sp_table_privileges syn keyword sqlFunction sp_tables syn keyword sqlFunction sp_tsql_environment syn keyword sqlFunction sp_tsql_feature_not_supported syn keyword sqlFunction sp_unbindefault syn keyword sqlFunction sp_unbindmsg syn keyword sqlFunction sp_unbindrule syn keyword sqlFunction sp_volchanged syn keyword sqlFunction sp_who syn keyword sqlFunction xp_scanf syn keyword sqlFunction xp_sprintf " server functions syn keyword sqlFunction col_length syn keyword sqlFunction col_name syn keyword sqlFunction index_col syn keyword sqlFunction object_id syn keyword sqlFunction object_name syn keyword sqlFunction proc_role syn keyword sqlFunction show_role syn keyword sqlFunction xp_cmdshell syn keyword sqlFunction xp_msver syn keyword sqlFunction xp_read_file syn keyword sqlFunction xp_real_cmdshell syn keyword sqlFunction xp_real_read_file syn keyword sqlFunction xp_real_sendmail syn keyword sqlFunction xp_real_startmail syn keyword sqlFunction xp_real_startsmtp syn keyword sqlFunction xp_real_stopmail syn keyword sqlFunction xp_real_stopsmtp syn keyword sqlFunction xp_real_write_file syn keyword sqlFunction xp_scanf syn keyword sqlFunction xp_sendmail syn keyword sqlFunction xp_sprintf syn keyword sqlFunction xp_startmail syn keyword sqlFunction xp_startsmtp syn keyword sqlFunction xp_stopmail syn keyword sqlFunction xp_stopsmtp syn keyword sqlFunction xp_write_file " http functions syn keyword sqlFunction http_header http_variable syn keyword sqlFunction next_http_header next_http_variable syn keyword sqlFunction sa_set_http_header sa_set_http_option syn keyword sqlFunction sa_http_variable_info sa_http_header_info " http functions 9.0.1 syn keyword sqlFunction http_encode http_decode syn keyword sqlFunction html_encode html_decode " keywords syn keyword sqlKeyword absolute action activ add address after syn keyword sqlKeyword algorithm allow_dup_row syn keyword sqlKeyword alter and any as asc ascii ase at atomic syn keyword sqlKeyword attended audit authorization syn keyword sqlKeyword autoincrement autostop bcp before syn keyword sqlKeyword between blank syn keyword sqlKeyword blanks block bottom unbounded break bufferpool syn keyword sqlKeyword bulk by byte cache calibrate calibration syn keyword sqlKeyword capability cascade cast syn keyword sqlKeyword catalog changes char char_convert check syn keyword sqlKeyword class classes client syn keyword sqlKeyword cluster clustered collation column syn keyword sqlKeyword command comment comparisons syn keyword sqlKeyword compatible component compressed compute syn keyword sqlKeyword concat confirm connection syn keyword sqlKeyword console consolidate consolidated syn keyword sqlKeyword constraint constraints continue syn keyword sqlKeyword convert count crc cross cube syn keyword sqlKeyword current cursor data data database syn keyword sqlKeyword current_timestamp current_user syn keyword sqlKeyword datatype dba dbfile syn keyword sqlKeyword dbspace debug syn keyword sqlKeyword decrypted default defaults definition syn keyword sqlKeyword delay deleting delimited desc syn keyword sqlKeyword description deterministic directory syn keyword sqlKeyword disable distinct do domain syn keyword sqlKeyword dsetpass dttm dynamic each editproc ejb syn keyword sqlKeyword else elseif enable encrypted end endif syn keyword sqlKeyword engine erase error escape escapes event syn keyword sqlKeyword every exception exclusive exec syn keyword sqlKeyword existing exists expanded express syn keyword sqlKeyword external externlogin factor false syn keyword sqlKeyword fastfirstrow fieldproc file filler syn keyword sqlKeyword fillfactor finish first first_keyword syn keyword sqlKeyword following force foreign format syn keyword sqlKeyword freepage full function go global syn keyword sqlKeyword group handler hash having hexadecimal syn keyword sqlKeyword hidden high hng hold holdlock syn keyword sqlKeyword hours id identified identity ignore syn keyword sqlKeyword ignore_dup_key ignore_dup_row immediate syn keyword sqlKeyword in inactive incremental index info inner syn keyword sqlKeyword inout insensitive inserting syn keyword sqlKeyword instead integrated syn keyword sqlKeyword internal into iq is isolation jar java syn keyword sqlKeyword jconnect jdk join kb key language last syn keyword sqlKeyword last_keyword lateral left level like syn keyword sqlKeyword limit local location log syn keyword sqlKeyword logging login long low main syn keyword sqlKeyword match max maximum membership syn keyword sqlKeyword minutes mirror mode modify monitor syn keyword sqlKeyword name named native natural new next no syn keyword sqlKeyword noholdlock nolock nonclustered none not syn keyword sqlKeyword notify null nulls of off old on syn keyword sqlKeyword only optimization optimizer option syn keyword sqlKeyword or order others out outer over syn keyword sqlKeyword package packetsize padding page pages syn keyword sqlKeyword paglock parallel part partition path syn keyword sqlKeyword pctfree plan preceding precision prefetch prefix syn keyword sqlKeyword preserve preview primary syn keyword sqlKeyword prior priqty private privileges syn keyword sqlKeyword procedure public publication publish publisher syn keyword sqlKeyword quotes range readcommitted syn keyword sqlKeyword readpast readuncommitted syn keyword sqlKeyword received recompile recursive references syn keyword sqlKeyword referencing relative syn keyword sqlKeyword rename repeatableread syn keyword sqlKeyword replicate rereceive resend reset syn keyword sqlKeyword resolve resource respect syn keyword sqlKeyword restrict result retain syn keyword sqlKeyword returns right syn keyword sqlKeyword rollup row rowlock rows save syn keyword sqlKeyword schedule schema scroll seconds secqty syn keyword sqlKeyword send sensitive sent serializable syn keyword sqlKeyword server server session sets syn keyword sqlKeyword share since site size skip syn keyword sqlKeyword some sorted_data sqlcode sqlid syn keyword sqlKeyword sqlstate stacker statement syn keyword sqlKeyword statistics status stogroup store syn keyword sqlKeyword strip subpages subscribe subscription syn keyword sqlKeyword subtransaction synchronization syn keyword sqlKeyword syntax_error table tablock syn keyword sqlKeyword tablockx tb temp template temporary then syn keyword sqlKeyword timezone to top syn keyword sqlKeyword transaction transactional tries true syn keyword sqlKeyword tsequal type unconditionally unenforced syn keyword sqlKeyword unique union unknown unload syn keyword sqlKeyword updating updlock upgrade use user syn keyword sqlKeyword using utc utilities validproc syn keyword sqlKeyword value values varchar variable syn keyword sqlKeyword varying vcat verify view virtual wait syn keyword sqlKeyword warning wd when where window with within syn keyword sqlKeyword with_lparen work writefile syn keyword sqlKeyword xlock zeros " XML function support syn keyword sqlFunction openxml xmlelement xmlforest xmlgen xmlconcat xmlagg syn keyword sqlFunction xmlattributes syn keyword sqlKeyword raw auto elements explicit " HTTP support syn keyword sqlKeyword authorization secure url service " HTTP 9.0.2 new procedure keywords syn keyword sqlKeyword namespace certificate clientport proxy " OLAP support 9.0.0 syn keyword sqlKeyword covar_pop covar_samp corr regr_slope regr_intercept syn keyword sqlKeyword regr_count regr_r2 regr_avgx regr_avgy syn keyword sqlKeyword regr_sxx regr_syy regr_sxy " Alternate keywords syn keyword sqlKeyword character dec options proc reference syn keyword sqlKeyword subtrans tran syn keyword syn keyword sqlOperator in any some all between exists syn keyword sqlOperator like escape not is and or syn keyword sqlOperator intersect minus syn keyword sqlOperator prior distinct syn keyword sqlStatement allocate alter backup begin call case syn keyword sqlStatement checkpoint clear close commit configure connect syn keyword sqlStatement create deallocate declare delete describe syn keyword sqlStatement disconnect drop execute exit explain fetch syn keyword sqlStatement for forward from get goto grant help if include syn keyword sqlStatement input insert install leave load lock loop syn keyword sqlStatement message open output parameter parameters passthrough syn keyword sqlStatement prepare print put raiserror read readtext release syn keyword sqlStatement remote remove reorganize resignal restore resume syn keyword sqlStatement return revoke rollback savepoint select syn keyword sqlStatement set setuser signal start stop synchronize syn keyword sqlStatement system trigger truncate unload update syn keyword sqlStatement validate waitfor whenever while writetext syn keyword sqlType char long varchar text syn keyword sqlType bigint decimal double float int integer numeric syn keyword sqlType smallint tinyint real syn keyword sqlType money smallmoney syn keyword sqlType bit syn keyword sqlType date datetime smalldate time timestamp syn keyword sqlType binary image varbinary uniqueidentifier syn keyword sqlType xml unsigned syn keyword sqlOption Allow_nulls_by_default syn keyword sqlOption Ansi_blanks syn keyword sqlOption Ansi_close_cursors_on_rollback syn keyword sqlOption Ansi_integer_overflow syn keyword sqlOption Ansi_permissions syn keyword sqlOption Ansi_update_constraints syn keyword sqlOption Ansinull syn keyword sqlOption Assume_distinct_servers syn keyword sqlOption Auditing syn keyword sqlOption Auditing_options syn keyword sqlOption Auto_commit syn keyword sqlOption Auto_refetch syn keyword sqlOption Automatic_timestamp syn keyword sqlOption Background_priority syn keyword sqlOption Bell syn keyword sqlOption Blob_threshold syn keyword sqlOption Blocking syn keyword sqlOption Blocking_timeout syn keyword sqlOption Chained syn keyword sqlOption Char_OEM_Translation syn keyword sqlOption Checkpoint_time syn keyword sqlOption Cis_option syn keyword sqlOption Cis_rowset_size syn keyword sqlOption Close_on_endtrans syn keyword sqlOption Command_delimiter syn keyword sqlOption Commit_on_exit syn keyword sqlOption Compression syn keyword sqlOption Connection_authentication syn keyword sqlOption Continue_after_raiserror syn keyword sqlOption Conversion_error syn keyword sqlOption Cooperative_commit_timeout syn keyword sqlOption Cooperative_commits syn keyword sqlOption Database_authentication syn keyword sqlOption Date_format syn keyword sqlOption Date_order syn keyword sqlOption Debug_messages syn keyword sqlOption Dedicated_task syn keyword sqlOption Default_timestamp_increment syn keyword sqlOption Delayed_commit_timeout syn keyword sqlOption Delayed_commits syn keyword sqlOption Delete_old_logs syn keyword sqlOption Describe_Java_Format syn keyword sqlOption Divide_by_zero_error syn keyword sqlOption Echo syn keyword sqlOption Escape_character syn keyword sqlOption Exclude_operators syn keyword sqlOption Extended_join_syntax syn keyword sqlOption External_remote_options syn keyword sqlOption Fire_triggers syn keyword sqlOption First_day_of_week syn keyword sqlOption Float_as_double syn keyword sqlOption For_xml_null_treatment syn keyword sqlOption Force_view_creation syn keyword sqlOption Global_database_id syn keyword sqlOption Headings syn keyword sqlOption Input_format syn keyword sqlOption Integrated_server_name syn keyword sqlOption Isolation_level syn keyword sqlOption ISQL_command_timing syn keyword sqlOption ISQL_escape_character syn keyword sqlOption ISQL_field_separator syn keyword sqlOption ISQL_log syn keyword sqlOption ISQL_plan syn keyword sqlOption ISQL_plan_cursor_sensitivity syn keyword sqlOption ISQL_plan_cursor_writability syn keyword sqlOption ISQL_quote syn keyword sqlOption Java_heap_size syn keyword sqlOption Java_input_output syn keyword sqlOption Java_namespace_size syn keyword sqlOption Java_page_buffer_size syn keyword sqlOption Lock_rejected_rows syn keyword sqlOption Log_deadlocks syn keyword sqlOption Log_detailed_plans syn keyword sqlOption Log_max_requests syn keyword sqlOption Login_mode syn keyword sqlOption Login_procedure syn keyword sqlOption Max_cursor_count syn keyword sqlOption Max_hash_size syn keyword sqlOption Max_plans_cached syn keyword sqlOption Max_recursive_iterations syn keyword sqlOption Max_statement_count syn keyword sqlOption Max_work_table_hash_size syn keyword sqlOption Min_password_length syn keyword sqlOption Nearest_century syn keyword sqlOption Non_keywords syn keyword sqlOption NULLS syn keyword sqlOption ODBC_describe_binary_as_varbinary syn keyword sqlOption ODBC_distinguish_char_and_varchar syn keyword sqlOption On_Charset_conversion_failure syn keyword sqlOption On_error syn keyword sqlOption On_tsql_error syn keyword sqlOption Optimistic_wait_for_commit syn keyword sqlOption Optimization_goal syn keyword sqlOption Optimization_level syn keyword sqlOption Optimization_logging syn keyword sqlOption Optimization_workload syn keyword sqlOption Output_format syn keyword sqlOption Output_length syn keyword sqlOption Output_nulls syn keyword sqlOption Percent_as_comment syn keyword sqlOption Pinned_cursor_percent_of_cache syn keyword sqlOption Precision syn keyword sqlOption Prefetch syn keyword sqlOption Preserve_source_format syn keyword sqlOption Prevent_article_pkey_update syn keyword sqlOption Qualify_owners syn keyword sqlOption Query_plan_on_open syn keyword sqlOption Quiet syn keyword sqlOption Quote_all_identifiers syn keyword sqlOption Quoted_identifier syn keyword sqlOption Read_past_deleted syn keyword sqlOption Recovery_time syn keyword sqlOption Remote_idle_timeout syn keyword sqlOption Replicate_all syn keyword sqlOption Replication_error syn keyword sqlOption Replication_error_piece syn keyword sqlOption Return_date_time_as_string syn keyword sqlOption Return_java_as_string syn keyword sqlOption RI_Trigger_time syn keyword sqlOption Rollback_on_deadlock syn keyword sqlOption Row_counts syn keyword sqlOption Save_remote_passwords syn keyword sqlOption Scale syn keyword sqlOption Screen_format syn keyword sqlOption Sort_Collation syn keyword sqlOption SQL_flagger_error_level syn keyword sqlOption SQL_flagger_warning_level syn keyword sqlOption SQLConnect syn keyword sqlOption SQLStart syn keyword sqlOption SR_Date_Format syn keyword sqlOption SR_Time_Format syn keyword sqlOption SR_TimeStamp_Format syn keyword sqlOption Statistics syn keyword sqlOption String_rtruncation syn keyword sqlOption Subscribe_by_remote syn keyword sqlOption Subsume_row_locks syn keyword sqlOption Suppress_TDS_debugging syn keyword sqlOption TDS_Empty_string_is_null syn keyword sqlOption Temp_space_limit_check syn keyword sqlOption Thread_count syn keyword sqlOption Thread_stack syn keyword sqlOption Thread_swaps syn keyword sqlOption Time_format syn keyword sqlOption Time_zone_adjustment syn keyword sqlOption Timestamp_format syn keyword sqlOption Truncate_date_values syn keyword sqlOption Truncate_timestamp_values syn keyword sqlOption Truncate_with_auto_commit syn keyword sqlOption Truncation_length syn keyword sqlOption Tsql_hex_constant syn keyword sqlOption Tsql_variables syn keyword sqlOption Update_statistics syn keyword sqlOption User_estimates syn keyword sqlOption Verify_all_columns syn keyword sqlOption Verify_threshold syn keyword sqlOption Wait_for_commit " Strings and characters: syn region sqlString start=+"+ end=+"+ contains=@Spell syn region sqlString start=+'+ end=+'+ contains=@Spell " Numbers: syn match sqlNumber "-\=\<\d*\.\=[0-9_]\>" " Comments: syn region sqlDashComment start=/--/ end=/$/ contains=@Spell syn region sqlSlashComment start=/\/\// end=/$/ contains=@Spell syn region sqlMultiComment start="/\*" end="\*/" contains=sqlMultiComment,@Spell syn cluster sqlComment contains=sqlDashComment,sqlSlashComment,sqlMultiComment,@Spell syn sync ccomment sqlComment syn sync ccomment sqlDashComment syn sync ccomment sqlSlashComment " Define the default highlighting. " For version 5.7 and earlier: only when not done already " For version 5.8 and later: only when an item doesn't have highlighting yet if version >= 508 || !exists("did_sql_syn_inits") if version < 508 let did_sql_syn_inits = 1 command -nargs=+ HiLink hi link else command -nargs=+ HiLink hi link endif HiLink sqlDashComment Comment HiLink sqlSlashComment Comment HiLink sqlMultiComment Comment HiLink sqlNumber Number HiLink sqlOperator Operator HiLink sqlSpecial Special HiLink sqlKeyword Keyword HiLink sqlStatement Statement HiLink sqlString String HiLink sqlType Type HiLink sqlFunction Function HiLink sqlOption PreProc delcommand HiLink endif let b:current_syntax = "sqlanywhere" " vim:sw=4:ff=unix: