" 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:
|
