| " Vim syntax file |
| " Language: SQL, Adaptive Server Anywhere |
| " Maintainer: David Fishburn <fishburn at ianywhere dot com> |
| " 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 <args> |
| else |
| command -nargs=+ HiLink hi link <args> |
| 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: |
