Mercurial > hg > RemoteEditor > vim7

comparison runtime/syntax/sqlanywhere.vim @ 34:e170173ecb68 current-release

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