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