|
719
|
1 " Vim syntax file
|
|
|
2 " Language: SQL, Adaptive Server Anywhere
|
|
3312
|
3 " Maintainer: David Fishburn <dfishburn dot vim at gmail dot com>
|
|
4437
|
4 " Last Change: 2013 May 13
|
|
|
5 " Version: 16.0.0
|
|
719
|
6
|
|
4437
|
7 " Description: Updated to Adaptive Server Anywhere 16.0.0
|
|
|
8 " Updated to Adaptive Server Anywhere 12.0.1 (including spatial data)
|
|
3312
|
9 " Updated to Adaptive Server Anywhere 11.0.1
|
|
2034
|
10 " Updated to Adaptive Server Anywhere 10.0.1
|
|
1621
|
11 " Updated to Adaptive Server Anywhere 9.0.2
|
|
|
12 " Updated to Adaptive Server Anywhere 9.0.1
|
|
|
13 " Updated to Adaptive Server Anywhere 9.0.0
|
|
719
|
14 "
|
|
|
15 " For version 5.x: Clear all syntax items
|
|
|
16 " For version 6.x: Quit when a syntax file was already loaded
|
|
|
17 if version < 600
|
|
|
18 syntax clear
|
|
|
19 elseif exists("b:current_syntax")
|
|
|
20 finish
|
|
|
21 endif
|
|
|
22
|
|
|
23 syn case ignore
|
|
|
24
|
|
|
25 " The SQL reserved words, defined as keywords.
|
|
|
26
|
|
|
27 syn keyword sqlSpecial false null true
|
|
|
28
|
|
|
29 " common functions
|
|
4437
|
30 syn keyword sqlFunction abs argn avg bintohex bintostr
|
|
|
31 syn keyword sqlFunction byte_length byte_substr char_length
|
|
|
32 syn keyword sqlFunction compare count count_big datalength date
|
|
|
33 syn keyword sqlFunction date_format dateadd datediff datename
|
|
|
34 syn keyword sqlFunction datepart day dayname days debug_eng
|
|
|
35 syn keyword sqlFunction dense_rank density dialect difference
|
|
|
36 syn keyword sqlFunction dow estimate estimate_source evaluate
|
|
|
37 syn keyword sqlFunction experience_estimate explanation
|
|
|
38 syn keyword sqlFunction get_identity graphical_plan
|
|
|
39 syn keyword sqlFunction graphical_ulplan greater grouping
|
|
|
40 syn keyword sqlFunction hextobin hextoint hour hours identity
|
|
|
41 syn keyword sqlFunction ifnull index_estimate inttohex isdate
|
|
|
42 syn keyword sqlFunction isencrypted isnull isnumeric
|
|
|
43 syn keyword sqlFunction lang_message length lesser like_end
|
|
|
44 syn keyword sqlFunction like_start list long_ulplan lookup max
|
|
|
45 syn keyword sqlFunction min minute minutes month monthname
|
|
|
46 syn keyword sqlFunction months newid now nullif number
|
|
|
47 syn keyword sqlFunction percent_rank plan quarter rand rank
|
|
|
48 syn keyword sqlFunction regexp_compile regexp_compile_patindex
|
|
|
49 syn keyword sqlFunction remainder rewrite rowid second seconds
|
|
|
50 syn keyword sqlFunction short_ulplan similar sortkey soundex
|
|
|
51 syn keyword sqlFunction stddev stack_trace str string strtobin strtouuid stuff
|
|
|
52 syn keyword sqlFunction subpartition substr substring sum switchoffset sysdatetimeoffset
|
|
|
53 syn keyword sqlFunction textptr todate todatetimeoffset today totimestamp traceback transactsql
|
|
|
54 syn keyword sqlFunction ts_index_statistics ts_table_statistics
|
|
|
55 syn keyword sqlFunction tsequal ulplan user_id user_name utc_now
|
|
|
56 syn keyword sqlFunction uuidtostr varexists variance watcomsql
|
|
|
57 syn keyword sqlFunction weeks wsql_state year years ymd
|
|
719
|
58
|
|
|
59 " 9.0.1 functions
|
|
2034
|
60 syn keyword sqlFunction acos asin atan atn2 cast ceiling convert cos cot
|
|
1621
|
61 syn keyword sqlFunction char_length coalesce dateformat datetime degrees exp
|
|
2034
|
62 syn keyword sqlFunction floor getdate insertstr
|
|
1621
|
63 syn keyword sqlFunction log log10 lower mod pi power
|
|
2034
|
64 syn keyword sqlFunction property radians replicate round sign sin
|
|
1621
|
65 syn keyword sqlFunction sqldialect tan truncate truncnum
|
|
|
66 syn keyword sqlFunction base64_encode base64_decode
|
|
|
67 syn keyword sqlFunction hash compress decompress encrypt decrypt
|
|
719
|
68
|
|
2034
|
69 " 11.0.1 functions
|
|
|
70 syn keyword sqlFunction connection_extended_property text_handle_vector_match
|
|
|
71 syn keyword sqlFunction read_client_file write_client_file
|
|
|
72
|
|
3312
|
73 " 12.0.1 functions
|
|
|
74 syn keyword sqlFunction http_response_header
|
|
|
75
|
|
719
|
76 " string functions
|
|
1621
|
77 syn keyword sqlFunction ascii char left ltrim repeat
|
|
|
78 syn keyword sqlFunction space right rtrim trim lcase ucase
|
|
|
79 syn keyword sqlFunction locate charindex patindex replace
|
|
2034
|
80 syn keyword sqlFunction errormsg csconvert
|
|
719
|
81
|
|
|
82 " property functions
|
|
1621
|
83 syn keyword sqlFunction db_id db_name property_name
|
|
|
84 syn keyword sqlFunction property_description property_number
|
|
|
85 syn keyword sqlFunction next_connection next_database property
|
|
|
86 syn keyword sqlFunction connection_property db_property db_extended_property
|
|
|
87 syn keyword sqlFunction event_parmeter event_condition event_condition_name
|
|
719
|
88
|
|
|
89 " sa_ procedures
|
|
1621
|
90 syn keyword sqlFunction sa_add_index_consultant_analysis
|
|
|
91 syn keyword sqlFunction sa_add_workload_query
|
|
|
92 syn keyword sqlFunction sa_app_deregister
|
|
|
93 syn keyword sqlFunction sa_app_get_infoStr
|
|
|
94 syn keyword sqlFunction sa_app_get_status
|
|
|
95 syn keyword sqlFunction sa_app_register
|
|
|
96 syn keyword sqlFunction sa_app_registration_unlock
|
|
|
97 syn keyword sqlFunction sa_app_set_infoStr
|
|
|
98 syn keyword sqlFunction sa_audit_string
|
|
|
99 syn keyword sqlFunction sa_check_commit
|
|
|
100 syn keyword sqlFunction sa_checkpoint_execute
|
|
|
101 syn keyword sqlFunction sa_conn_activity
|
|
|
102 syn keyword sqlFunction sa_conn_compression_info
|
|
|
103 syn keyword sqlFunction sa_conn_deregister
|
|
|
104 syn keyword sqlFunction sa_conn_info
|
|
|
105 syn keyword sqlFunction sa_conn_properties
|
|
|
106 syn keyword sqlFunction sa_conn_properties_by_conn
|
|
|
107 syn keyword sqlFunction sa_conn_properties_by_name
|
|
|
108 syn keyword sqlFunction sa_conn_register
|
|
|
109 syn keyword sqlFunction sa_conn_set_status
|
|
|
110 syn keyword sqlFunction sa_create_analysis_from_query
|
|
|
111 syn keyword sqlFunction sa_db_info
|
|
|
112 syn keyword sqlFunction sa_db_properties
|
|
|
113 syn keyword sqlFunction sa_disable_auditing_type
|
|
|
114 syn keyword sqlFunction sa_disable_index
|
|
|
115 syn keyword sqlFunction sa_disk_free_space
|
|
|
116 syn keyword sqlFunction sa_enable_auditing_type
|
|
|
117 syn keyword sqlFunction sa_enable_index
|
|
|
118 syn keyword sqlFunction sa_end_forward_to
|
|
|
119 syn keyword sqlFunction sa_eng_properties
|
|
|
120 syn keyword sqlFunction sa_event_schedules
|
|
|
121 syn keyword sqlFunction sa_exec_script
|
|
|
122 syn keyword sqlFunction sa_flush_cache
|
|
|
123 syn keyword sqlFunction sa_flush_statistics
|
|
|
124 syn keyword sqlFunction sa_forward_to
|
|
|
125 syn keyword sqlFunction sa_get_dtt
|
|
|
126 syn keyword sqlFunction sa_get_histogram
|
|
|
127 syn keyword sqlFunction sa_get_request_profile
|
|
|
128 syn keyword sqlFunction sa_get_request_profile_sub
|
|
|
129 syn keyword sqlFunction sa_get_request_times
|
|
|
130 syn keyword sqlFunction sa_get_server_messages
|
|
|
131 syn keyword sqlFunction sa_get_simulated_scale_factors
|
|
|
132 syn keyword sqlFunction sa_get_workload_capture_status
|
|
|
133 syn keyword sqlFunction sa_index_density
|
|
|
134 syn keyword sqlFunction sa_index_levels
|
|
|
135 syn keyword sqlFunction sa_index_statistics
|
|
|
136 syn keyword sqlFunction sa_internal_alter_index_ability
|
|
|
137 syn keyword sqlFunction sa_internal_create_analysis_from_query
|
|
|
138 syn keyword sqlFunction sa_internal_disk_free_space
|
|
|
139 syn keyword sqlFunction sa_internal_get_dtt
|
|
|
140 syn keyword sqlFunction sa_internal_get_histogram
|
|
|
141 syn keyword sqlFunction sa_internal_get_request_times
|
|
|
142 syn keyword sqlFunction sa_internal_get_simulated_scale_factors
|
|
|
143 syn keyword sqlFunction sa_internal_get_workload_capture_status
|
|
|
144 syn keyword sqlFunction sa_internal_index_density
|
|
|
145 syn keyword sqlFunction sa_internal_index_levels
|
|
|
146 syn keyword sqlFunction sa_internal_index_statistics
|
|
|
147 syn keyword sqlFunction sa_internal_java_loaded_classes
|
|
|
148 syn keyword sqlFunction sa_internal_locks
|
|
|
149 syn keyword sqlFunction sa_internal_pause_workload_capture
|
|
|
150 syn keyword sqlFunction sa_internal_procedure_profile
|
|
|
151 syn keyword sqlFunction sa_internal_procedure_profile_summary
|
|
|
152 syn keyword sqlFunction sa_internal_read_backup_history
|
|
|
153 syn keyword sqlFunction sa_internal_recommend_indexes
|
|
|
154 syn keyword sqlFunction sa_internal_reset_identity
|
|
|
155 syn keyword sqlFunction sa_internal_resume_workload_capture
|
|
|
156 syn keyword sqlFunction sa_internal_start_workload_capture
|
|
|
157 syn keyword sqlFunction sa_internal_stop_index_consultant
|
|
|
158 syn keyword sqlFunction sa_internal_stop_workload_capture
|
|
|
159 syn keyword sqlFunction sa_internal_table_fragmentation
|
|
|
160 syn keyword sqlFunction sa_internal_table_page_usage
|
|
|
161 syn keyword sqlFunction sa_internal_table_stats
|
|
|
162 syn keyword sqlFunction sa_internal_virtual_sysindex
|
|
|
163 syn keyword sqlFunction sa_internal_virtual_sysixcol
|
|
|
164 syn keyword sqlFunction sa_java_loaded_classes
|
|
|
165 syn keyword sqlFunction sa_jdk_version
|
|
|
166 syn keyword sqlFunction sa_locks
|
|
|
167 syn keyword sqlFunction sa_make_object
|
|
|
168 syn keyword sqlFunction sa_pause_workload_capture
|
|
|
169 syn keyword sqlFunction sa_proc_debug_attach_to_connection
|
|
|
170 syn keyword sqlFunction sa_proc_debug_connect
|
|
|
171 syn keyword sqlFunction sa_proc_debug_detach_from_connection
|
|
|
172 syn keyword sqlFunction sa_proc_debug_disconnect
|
|
|
173 syn keyword sqlFunction sa_proc_debug_get_connection_name
|
|
|
174 syn keyword sqlFunction sa_proc_debug_release_connection
|
|
|
175 syn keyword sqlFunction sa_proc_debug_request
|
|
|
176 syn keyword sqlFunction sa_proc_debug_version
|
|
|
177 syn keyword sqlFunction sa_proc_debug_wait_for_connection
|
|
|
178 syn keyword sqlFunction sa_procedure_profile
|
|
|
179 syn keyword sqlFunction sa_procedure_profile_summary
|
|
|
180 syn keyword sqlFunction sa_read_backup_history
|
|
|
181 syn keyword sqlFunction sa_recommend_indexes
|
|
|
182 syn keyword sqlFunction sa_recompile_views
|
|
|
183 syn keyword sqlFunction sa_remove_index_consultant_analysis
|
|
|
184 syn keyword sqlFunction sa_remove_index_consultant_workload
|
|
|
185 syn keyword sqlFunction sa_reset_identity
|
|
|
186 syn keyword sqlFunction sa_resume_workload_capture
|
|
|
187 syn keyword sqlFunction sa_server_option
|
|
|
188 syn keyword sqlFunction sa_set_simulated_scale_factor
|
|
|
189 syn keyword sqlFunction sa_setremoteuser
|
|
|
190 syn keyword sqlFunction sa_setsubscription
|
|
|
191 syn keyword sqlFunction sa_start_recording_commits
|
|
|
192 syn keyword sqlFunction sa_start_workload_capture
|
|
|
193 syn keyword sqlFunction sa_statement_text
|
|
|
194 syn keyword sqlFunction sa_stop_index_consultant
|
|
|
195 syn keyword sqlFunction sa_stop_recording_commits
|
|
|
196 syn keyword sqlFunction sa_stop_workload_capture
|
|
|
197 syn keyword sqlFunction sa_sync
|
|
|
198 syn keyword sqlFunction sa_sync_sub
|
|
|
199 syn keyword sqlFunction sa_table_fragmentation
|
|
|
200 syn keyword sqlFunction sa_table_page_usage
|
|
|
201 syn keyword sqlFunction sa_table_stats
|
|
|
202 syn keyword sqlFunction sa_update_index_consultant_workload
|
|
|
203 syn keyword sqlFunction sa_validate
|
|
|
204 syn keyword sqlFunction sa_virtual_sysindex
|
|
|
205 syn keyword sqlFunction sa_virtual_sysixcol
|
|
719
|
206
|
|
|
207 " sp_ procedures
|
|
1621
|
208 syn keyword sqlFunction sp_addalias
|
|
|
209 syn keyword sqlFunction sp_addauditrecord
|
|
|
210 syn keyword sqlFunction sp_adddumpdevice
|
|
|
211 syn keyword sqlFunction sp_addgroup
|
|
|
212 syn keyword sqlFunction sp_addlanguage
|
|
|
213 syn keyword sqlFunction sp_addlogin
|
|
|
214 syn keyword sqlFunction sp_addmessage
|
|
|
215 syn keyword sqlFunction sp_addremotelogin
|
|
|
216 syn keyword sqlFunction sp_addsegment
|
|
|
217 syn keyword sqlFunction sp_addserver
|
|
|
218 syn keyword sqlFunction sp_addthreshold
|
|
|
219 syn keyword sqlFunction sp_addtype
|
|
|
220 syn keyword sqlFunction sp_adduser
|
|
|
221 syn keyword sqlFunction sp_auditdatabase
|
|
|
222 syn keyword sqlFunction sp_auditlogin
|
|
|
223 syn keyword sqlFunction sp_auditobject
|
|
|
224 syn keyword sqlFunction sp_auditoption
|
|
|
225 syn keyword sqlFunction sp_auditsproc
|
|
|
226 syn keyword sqlFunction sp_bindefault
|
|
|
227 syn keyword sqlFunction sp_bindmsg
|
|
|
228 syn keyword sqlFunction sp_bindrule
|
|
|
229 syn keyword sqlFunction sp_changedbowner
|
|
|
230 syn keyword sqlFunction sp_changegroup
|
|
|
231 syn keyword sqlFunction sp_checknames
|
|
|
232 syn keyword sqlFunction sp_checkperms
|
|
|
233 syn keyword sqlFunction sp_checkreswords
|
|
|
234 syn keyword sqlFunction sp_clearstats
|
|
|
235 syn keyword sqlFunction sp_column_privileges
|
|
|
236 syn keyword sqlFunction sp_columns
|
|
|
237 syn keyword sqlFunction sp_commonkey
|
|
|
238 syn keyword sqlFunction sp_configure
|
|
|
239 syn keyword sqlFunction sp_cursorinfo
|
|
|
240 syn keyword sqlFunction sp_databases
|
|
|
241 syn keyword sqlFunction sp_datatype_info
|
|
|
242 syn keyword sqlFunction sp_dboption
|
|
|
243 syn keyword sqlFunction sp_dbremap
|
|
|
244 syn keyword sqlFunction sp_depends
|
|
|
245 syn keyword sqlFunction sp_diskdefault
|
|
|
246 syn keyword sqlFunction sp_displaylogin
|
|
|
247 syn keyword sqlFunction sp_dropalias
|
|
|
248 syn keyword sqlFunction sp_dropdevice
|
|
|
249 syn keyword sqlFunction sp_dropgroup
|
|
|
250 syn keyword sqlFunction sp_dropkey
|
|
|
251 syn keyword sqlFunction sp_droplanguage
|
|
|
252 syn keyword sqlFunction sp_droplogin
|
|
|
253 syn keyword sqlFunction sp_dropmessage
|
|
|
254 syn keyword sqlFunction sp_dropremotelogin
|
|
|
255 syn keyword sqlFunction sp_dropsegment
|
|
|
256 syn keyword sqlFunction sp_dropserver
|
|
|
257 syn keyword sqlFunction sp_dropthreshold
|
|
|
258 syn keyword sqlFunction sp_droptype
|
|
|
259 syn keyword sqlFunction sp_dropuser
|
|
|
260 syn keyword sqlFunction sp_estspace
|
|
|
261 syn keyword sqlFunction sp_extendsegment
|
|
|
262 syn keyword sqlFunction sp_fkeys
|
|
|
263 syn keyword sqlFunction sp_foreignkey
|
|
|
264 syn keyword sqlFunction sp_getmessage
|
|
|
265 syn keyword sqlFunction sp_help
|
|
|
266 syn keyword sqlFunction sp_helpconstraint
|
|
|
267 syn keyword sqlFunction sp_helpdb
|
|
|
268 syn keyword sqlFunction sp_helpdevice
|
|
|
269 syn keyword sqlFunction sp_helpgroup
|
|
|
270 syn keyword sqlFunction sp_helpindex
|
|
|
271 syn keyword sqlFunction sp_helpjoins
|
|
|
272 syn keyword sqlFunction sp_helpkey
|
|
|
273 syn keyword sqlFunction sp_helplanguage
|
|
|
274 syn keyword sqlFunction sp_helplog
|
|
|
275 syn keyword sqlFunction sp_helpprotect
|
|
|
276 syn keyword sqlFunction sp_helpremotelogin
|
|
|
277 syn keyword sqlFunction sp_helpsegment
|
|
|
278 syn keyword sqlFunction sp_helpserver
|
|
|
279 syn keyword sqlFunction sp_helpsort
|
|
|
280 syn keyword sqlFunction sp_helptext
|
|
|
281 syn keyword sqlFunction sp_helpthreshold
|
|
|
282 syn keyword sqlFunction sp_helpuser
|
|
|
283 syn keyword sqlFunction sp_indsuspect
|
|
|
284 syn keyword sqlFunction sp_lock
|
|
|
285 syn keyword sqlFunction sp_locklogin
|
|
|
286 syn keyword sqlFunction sp_logdevice
|
|
|
287 syn keyword sqlFunction sp_login_environment
|
|
|
288 syn keyword sqlFunction sp_modifylogin
|
|
|
289 syn keyword sqlFunction sp_modifythreshold
|
|
|
290 syn keyword sqlFunction sp_monitor
|
|
|
291 syn keyword sqlFunction sp_password
|
|
|
292 syn keyword sqlFunction sp_pkeys
|
|
|
293 syn keyword sqlFunction sp_placeobject
|
|
|
294 syn keyword sqlFunction sp_primarykey
|
|
|
295 syn keyword sqlFunction sp_procxmode
|
|
|
296 syn keyword sqlFunction sp_recompile
|
|
|
297 syn keyword sqlFunction sp_remap
|
|
|
298 syn keyword sqlFunction sp_remote_columns
|
|
|
299 syn keyword sqlFunction sp_remote_exported_keys
|
|
|
300 syn keyword sqlFunction sp_remote_imported_keys
|
|
|
301 syn keyword sqlFunction sp_remote_pcols
|
|
|
302 syn keyword sqlFunction sp_remote_primary_keys
|
|
|
303 syn keyword sqlFunction sp_remote_procedures
|
|
|
304 syn keyword sqlFunction sp_remote_tables
|
|
|
305 syn keyword sqlFunction sp_remoteoption
|
|
|
306 syn keyword sqlFunction sp_rename
|
|
|
307 syn keyword sqlFunction sp_renamedb
|
|
|
308 syn keyword sqlFunction sp_reportstats
|
|
|
309 syn keyword sqlFunction sp_reset_tsql_environment
|
|
|
310 syn keyword sqlFunction sp_role
|
|
|
311 syn keyword sqlFunction sp_server_info
|
|
|
312 syn keyword sqlFunction sp_servercaps
|
|
|
313 syn keyword sqlFunction sp_serverinfo
|
|
|
314 syn keyword sqlFunction sp_serveroption
|
|
|
315 syn keyword sqlFunction sp_setlangalias
|
|
|
316 syn keyword sqlFunction sp_setreplicate
|
|
|
317 syn keyword sqlFunction sp_setrepproc
|
|
|
318 syn keyword sqlFunction sp_setreptable
|
|
|
319 syn keyword sqlFunction sp_spaceused
|
|
|
320 syn keyword sqlFunction sp_special_columns
|
|
|
321 syn keyword sqlFunction sp_sproc_columns
|
|
|
322 syn keyword sqlFunction sp_statistics
|
|
|
323 syn keyword sqlFunction sp_stored_procedures
|
|
|
324 syn keyword sqlFunction sp_syntax
|
|
|
325 syn keyword sqlFunction sp_table_privileges
|
|
|
326 syn keyword sqlFunction sp_tables
|
|
|
327 syn keyword sqlFunction sp_tsql_environment
|
|
|
328 syn keyword sqlFunction sp_tsql_feature_not_supported
|
|
|
329 syn keyword sqlFunction sp_unbindefault
|
|
|
330 syn keyword sqlFunction sp_unbindmsg
|
|
|
331 syn keyword sqlFunction sp_unbindrule
|
|
|
332 syn keyword sqlFunction sp_volchanged
|
|
|
333 syn keyword sqlFunction sp_who
|
|
|
334 syn keyword sqlFunction xp_scanf
|
|
|
335 syn keyword sqlFunction xp_sprintf
|
|
719
|
336
|
|
|
337 " server functions
|
|
1621
|
338 syn keyword sqlFunction col_length
|
|
|
339 syn keyword sqlFunction col_name
|
|
|
340 syn keyword sqlFunction index_col
|
|
|
341 syn keyword sqlFunction object_id
|
|
|
342 syn keyword sqlFunction object_name
|
|
|
343 syn keyword sqlFunction proc_role
|
|
|
344 syn keyword sqlFunction show_role
|
|
|
345 syn keyword sqlFunction xp_cmdshell
|
|
|
346 syn keyword sqlFunction xp_msver
|
|
|
347 syn keyword sqlFunction xp_read_file
|
|
|
348 syn keyword sqlFunction xp_real_cmdshell
|
|
|
349 syn keyword sqlFunction xp_real_read_file
|
|
|
350 syn keyword sqlFunction xp_real_sendmail
|
|
|
351 syn keyword sqlFunction xp_real_startmail
|
|
|
352 syn keyword sqlFunction xp_real_startsmtp
|
|
|
353 syn keyword sqlFunction xp_real_stopmail
|
|
|
354 syn keyword sqlFunction xp_real_stopsmtp
|
|
|
355 syn keyword sqlFunction xp_real_write_file
|
|
|
356 syn keyword sqlFunction xp_scanf
|
|
|
357 syn keyword sqlFunction xp_sendmail
|
|
|
358 syn keyword sqlFunction xp_sprintf
|
|
|
359 syn keyword sqlFunction xp_startmail
|
|
|
360 syn keyword sqlFunction xp_startsmtp
|
|
|
361 syn keyword sqlFunction xp_stopmail
|
|
|
362 syn keyword sqlFunction xp_stopsmtp
|
|
|
363 syn keyword sqlFunction xp_write_file
|
|
719
|
364
|
|
|
365 " http functions
|
|
1621
|
366 syn keyword sqlFunction http_header http_variable
|
|
3312
|
367 syn keyword sqlFunction next_http_header next_http_response_header next_http_variable
|
|
1621
|
368 syn keyword sqlFunction sa_set_http_header sa_set_http_option
|
|
|
369 syn keyword sqlFunction sa_http_variable_info sa_http_header_info
|
|
719
|
370
|
|
2034
|
371 " http functions 9.0.1
|
|
1621
|
372 syn keyword sqlFunction http_encode http_decode
|
|
|
373 syn keyword sqlFunction html_encode html_decode
|
|
719
|
374
|
|
3312
|
375 " XML function support
|
|
|
376 syn keyword sqlFunction openxml xmlelement xmlforest xmlgen xmlconcat xmlagg
|
|
|
377 syn keyword sqlFunction xmlattributes
|
|
|
378
|
|
|
379 " Spatial Compatibility Functions
|
|
|
380 syn keyword sqlFunction ST_BdMPolyFromText
|
|
|
381 syn keyword sqlFunction ST_BdMPolyFromWKB
|
|
|
382 syn keyword sqlFunction ST_BdPolyFromText
|
|
|
383 syn keyword sqlFunction ST_BdPolyFromWKB
|
|
|
384 syn keyword sqlFunction ST_CPolyFromText
|
|
|
385 syn keyword sqlFunction ST_CPolyFromWKB
|
|
|
386 syn keyword sqlFunction ST_CircularFromTxt
|
|
|
387 syn keyword sqlFunction ST_CircularFromWKB
|
|
|
388 syn keyword sqlFunction ST_CompoundFromTxt
|
|
|
389 syn keyword sqlFunction ST_CompoundFromWKB
|
|
|
390 syn keyword sqlFunction ST_GeomCollFromTxt
|
|
|
391 syn keyword sqlFunction ST_GeomCollFromWKB
|
|
|
392 syn keyword sqlFunction ST_GeomFromText
|
|
|
393 syn keyword sqlFunction ST_GeomFromWKB
|
|
|
394 syn keyword sqlFunction ST_LineFromText
|
|
|
395 syn keyword sqlFunction ST_LineFromWKB
|
|
|
396 syn keyword sqlFunction ST_MCurveFromText
|
|
|
397 syn keyword sqlFunction ST_MCurveFromWKB
|
|
|
398 syn keyword sqlFunction ST_MLineFromText
|
|
|
399 syn keyword sqlFunction ST_MLineFromWKB
|
|
|
400 syn keyword sqlFunction ST_MPointFromText
|
|
|
401 syn keyword sqlFunction ST_MPointFromWKB
|
|
|
402 syn keyword sqlFunction ST_MPolyFromText
|
|
|
403 syn keyword sqlFunction ST_MPolyFromWKB
|
|
|
404 syn keyword sqlFunction ST_MSurfaceFromTxt
|
|
|
405 syn keyword sqlFunction ST_MSurfaceFromWKB
|
|
|
406 syn keyword sqlFunction ST_OrderingEquals
|
|
|
407 syn keyword sqlFunction ST_PointFromText
|
|
|
408 syn keyword sqlFunction ST_PointFromWKB
|
|
|
409 syn keyword sqlFunction ST_PolyFromText
|
|
|
410 syn keyword sqlFunction ST_PolyFromWKB
|
|
|
411 " Spatial Structural Methods
|
|
|
412 syn keyword sqlFunction ST_CoordDim
|
|
|
413 syn keyword sqlFunction ST_CurveN
|
|
|
414 syn keyword sqlFunction ST_Dimension
|
|
|
415 syn keyword sqlFunction ST_EndPoint
|
|
|
416 syn keyword sqlFunction ST_ExteriorRing
|
|
|
417 syn keyword sqlFunction ST_GeometryN
|
|
|
418 syn keyword sqlFunction ST_GeometryType
|
|
|
419 syn keyword sqlFunction ST_InteriorRingN
|
|
|
420 syn keyword sqlFunction ST_Is3D
|
|
|
421 syn keyword sqlFunction ST_IsClosed
|
|
|
422 syn keyword sqlFunction ST_IsEmpty
|
|
|
423 syn keyword sqlFunction ST_IsMeasured
|
|
|
424 syn keyword sqlFunction ST_IsRing
|
|
|
425 syn keyword sqlFunction ST_IsSimple
|
|
|
426 syn keyword sqlFunction ST_IsValid
|
|
|
427 syn keyword sqlFunction ST_NumCurves
|
|
|
428 syn keyword sqlFunction ST_NumGeometries
|
|
|
429 syn keyword sqlFunction ST_NumInteriorRing
|
|
|
430 syn keyword sqlFunction ST_NumPoints
|
|
|
431 syn keyword sqlFunction ST_PointN
|
|
|
432 syn keyword sqlFunction ST_StartPoint
|
|
|
433 "Spatial Computation
|
|
|
434 syn keyword sqlFunction ST_Length
|
|
|
435 syn keyword sqlFunction ST_Area
|
|
|
436 syn keyword sqlFunction ST_Centroid
|
|
|
437 syn keyword sqlFunction ST_Area
|
|
|
438 syn keyword sqlFunction ST_Centroid
|
|
|
439 syn keyword sqlFunction ST_IsWorld
|
|
|
440 syn keyword sqlFunction ST_Perimeter
|
|
|
441 syn keyword sqlFunction ST_PointOnSurface
|
|
|
442 syn keyword sqlFunction ST_Distance
|
|
|
443 " Spatial Input/Output
|
|
|
444 syn keyword sqlFunction ST_AsBinary
|
|
|
445 syn keyword sqlFunction ST_AsGML
|
|
|
446 syn keyword sqlFunction ST_AsGeoJSON
|
|
|
447 syn keyword sqlFunction ST_AsSVG
|
|
|
448 syn keyword sqlFunction ST_AsSVGAggr
|
|
|
449 syn keyword sqlFunction ST_AsText
|
|
|
450 syn keyword sqlFunction ST_AsWKB
|
|
|
451 syn keyword sqlFunction ST_AsWKT
|
|
|
452 syn keyword sqlFunction ST_AsXML
|
|
|
453 syn keyword sqlFunction ST_GeomFromBinary
|
|
|
454 syn keyword sqlFunction ST_GeomFromShape
|
|
|
455 syn keyword sqlFunction ST_GeomFromText
|
|
|
456 syn keyword sqlFunction ST_GeomFromWKB
|
|
|
457 syn keyword sqlFunction ST_GeomFromWKT
|
|
|
458 syn keyword sqlFunction ST_GeomFromXML
|
|
|
459 " Spatial Cast Methods
|
|
|
460 syn keyword sqlFunction ST_CurvePolyToPoly
|
|
|
461 syn keyword sqlFunction ST_CurveToLine
|
|
|
462 syn keyword sqlFunction ST_ToCircular
|
|
|
463 syn keyword sqlFunction ST_ToCompound
|
|
|
464 syn keyword sqlFunction ST_ToCurve
|
|
|
465 syn keyword sqlFunction ST_ToCurvePoly
|
|
|
466 syn keyword sqlFunction ST_ToGeomColl
|
|
|
467 syn keyword sqlFunction ST_ToLineString
|
|
|
468 syn keyword sqlFunction ST_ToMultiCurve
|
|
|
469 syn keyword sqlFunction ST_ToMultiLine
|
|
|
470 syn keyword sqlFunction ST_ToMultiPoint
|
|
|
471 syn keyword sqlFunction ST_ToMultiPolygon
|
|
|
472 syn keyword sqlFunction ST_ToMultiSurface
|
|
|
473 syn keyword sqlFunction ST_ToPoint
|
|
|
474 syn keyword sqlFunction ST_ToPolygon
|
|
|
475 syn keyword sqlFunction ST_ToSurface
|
|
|
476
|
|
4437
|
477 " Array functions 16.x
|
|
|
478 syn keyword sqlFunction array array_agg array_max_cardinality trim_array
|
|
|
479 syn keyword sqlFunction error_line error_message error_procedure
|
|
|
480 syn keyword sqlFunction error_sqlcode error_sqlstate error_stack_trace
|
|
|
481
|
|
3312
|
482
|
|
719
|
483 " keywords
|
|
4437
|
484 syn keyword sqlKeyword absolute accent access account action active activate add address admin
|
|
|
485 syn keyword sqlKeyword aes_decrypt after aggregate algorithm allow_dup_row allow allowed alter
|
|
|
486 syn keyword sqlKeyword always and angular ansi_substring any as append apply
|
|
|
487 syn keyword sqlKeyword arbiter array asc ascii ase
|
|
|
488 syn keyword sqlKeyword assign at atan2 atomic attended
|
|
|
489 syn keyword sqlKeyword audit auditing authentication authorization axis
|
|
1621
|
490 syn keyword sqlKeyword autoincrement autostop batch bcp before
|
|
2034
|
491 syn keyword sqlKeyword between bit_and bit_length bit_or bit_substr bit_xor
|
|
|
492 syn keyword sqlKeyword blank blanks block
|
|
3312
|
493 syn keyword sqlKeyword both bottom unbounded breaker bufferpool
|
|
1621
|
494 syn keyword sqlKeyword build bulk by byte bytes cache calibrate calibration
|
|
4437
|
495 syn keyword sqlKeyword cancel capability cardinality cascade cast
|
|
|
496 syn keyword sqlKeyword catalog catch ceil change changes char char_convert
|
|
|
497 syn keyword sqlKeyword check checkpointlog checksum class classes client cmp
|
|
2034
|
498 syn keyword sqlKeyword cluster clustered collation
|
|
|
499 syn keyword sqlKeyword column columns
|
|
4437
|
500 syn keyword sqlKeyword command comments committed commitid comparisons
|
|
1621
|
501 syn keyword sqlKeyword compatible component compressed compute computes
|
|
2034
|
502 syn keyword sqlKeyword concat configuration confirm conflict connection
|
|
1621
|
503 syn keyword sqlKeyword console consolidate consolidated
|
|
4437
|
504 syn keyword sqlKeyword constraint constraints content
|
|
3312
|
505 syn keyword sqlKeyword convert coordinate coordinator copy count count_set_bits
|
|
4437
|
506 syn keyword sqlKeyword crc createtime critical cross cube cume_dist
|
|
1621
|
507 syn keyword sqlKeyword current cursor data data database
|
|
3312
|
508 syn keyword sqlKeyword current_timestamp current_user cycle
|
|
2034
|
509 syn keyword sqlKeyword databases datatype dba dbfile
|
|
|
510 syn keyword sqlKeyword dbspace dbspaces dbspacename debug decoupled
|
|
|
511 syn keyword sqlKeyword decrypted default defaults default_dbspace deferred
|
|
|
512 syn keyword sqlKeyword definer definition
|
|
1621
|
513 syn keyword sqlKeyword delay deleting delimited dependencies desc
|
|
3312
|
514 syn keyword sqlKeyword description deterministic directory
|
|
4437
|
515 syn keyword sqlKeyword disable disabled disallow distinct disksandbox disk_sandbox
|
|
|
516 syn keyword sqlKeyword dn do domain download duplicate
|
|
|
517 syn keyword sqlKeyword dsetpass dttm dynamic each earth editproc effective ejb
|
|
|
518 syn keyword sqlKeyword elimination ellipsoid else elseif
|
|
|
519 syn keyword sqlKeyword email empty enable encapsulated encrypted encryption end
|
|
|
520 syn keyword sqlKeyword encoding endif engine environment erase error errors escape escapes event
|
|
3312
|
521 syn keyword sqlKeyword event_parameter every exception exclude excluded exclusive exec
|
|
2034
|
522 syn keyword sqlKeyword existing exists expanded expiry express exprtype extended_property
|
|
1621
|
523 syn keyword sqlKeyword external externlogin factor failover false
|
|
3312
|
524 syn keyword sqlKeyword fastfirstrow feature fieldproc file files filler
|
|
|
525 syn keyword sqlKeyword fillfactor final finish first first_keyword first_value
|
|
|
526 syn keyword sqlKeyword flattening
|
|
4437
|
527 syn keyword sqlKeyword following force foreign format forjson forxml forxml_sep fp frame
|
|
|
528 syn keyword sqlKeyword free freepage french fresh full function
|
|
3312
|
529 syn keyword sqlKeyword gb generic get_bit go global grid
|
|
2034
|
530 syn keyword sqlKeyword group handler hash having header hexadecimal
|
|
|
531 syn keyword sqlKeyword hidden high history hg hng hold holdlock host
|
|
|
532 syn keyword sqlKeyword hours http_body http_session_timeout id identified identity ignore
|
|
1621
|
533 syn keyword sqlKeyword ignore_dup_key ignore_dup_row immediate
|
|
3312
|
534 syn keyword sqlKeyword in inactiv inactive inactivity included increment incremental
|
|
4437
|
535 syn keyword sqlKeyword index index_enabled index_lparen indexonly info information
|
|
|
536 syn keyword sqlKeyword inheritance inline inner inout insensitive inserting
|
|
|
537 syn keyword sqlKeyword instead
|
|
|
538 syn keyword sqlKeyword internal intersection into introduced inverse invoker
|
|
3312
|
539 syn keyword sqlKeyword iq is isolation
|
|
2034
|
540 syn keyword sqlKeyword jar java java_location java_main_userid java_vm_options
|
|
4437
|
541 syn keyword sqlKeyword jconnect jdk join json kb key keys keep language last
|
|
3312
|
542 syn keyword sqlKeyword last_keyword last_value lateral latitude
|
|
4437
|
543 syn keyword sqlKeyword ld ldap left len linear lf ln level like
|
|
|
544 syn keyword sqlKeyword limit local location log
|
|
3312
|
545 syn keyword sqlKeyword logging logical login logscan long longitude low lru ls
|
|
4437
|
546 syn keyword sqlKeyword main major manage manual mark master
|
|
|
547 syn keyword sqlKeyword match matched materialized max maxvalue maximum mb measure median membership
|
|
|
548 syn keyword sqlKeyword merge metadata methods migrate minimum minor minutes minvalue mirror
|
|
|
549 syn keyword sqlKeyword mode modify monitor move mru multiplex
|
|
|
550 syn keyword sqlKeyword name named namespaces national native natural new next nextval
|
|
3312
|
551 syn keyword sqlKeyword ngram no noholdlock nolock nonclustered none normal not
|
|
4437
|
552 syn keyword sqlKeyword notify null nullable_constant nulls
|
|
|
553 syn keyword sqlKeyword object objects oem_string of off offline offset olap
|
|
3312
|
554 syn keyword sqlKeyword old on online only openstring operator
|
|
|
555 syn keyword sqlKeyword optimization optimizer option
|
|
4437
|
556 syn keyword sqlKeyword or order ordinality organization others out outer over owner
|
|
1621
|
557 syn keyword sqlKeyword package packetsize padding page pages
|
|
4437
|
558 syn keyword sqlKeyword paglock parallel parameter parent part partial
|
|
|
559 syn keyword sqlKeyword partition partitions partner password path pctfree
|
|
|
560 syn keyword sqlKeyword permissions perms plan planar policy polygon populate port postfilter preceding
|
|
3312
|
561 syn keyword sqlKeyword precisionprefetch prefilter prefix preserve preview previous
|
|
4437
|
562 syn keyword sqlKeyword primary prior priority priqty private privilege privileges procedure profile profiling
|
|
2034
|
563 syn keyword sqlKeyword property_is_cumulative property_is_numeric public publication publish publisher
|
|
|
564 syn keyword sqlKeyword quiesce quote quotes range readclientfile readcommitted reader readfile readonly
|
|
1621
|
565 syn keyword sqlKeyword readpast readuncommitted readwrite rebuild
|
|
|
566 syn keyword sqlKeyword received recompile recover recursive references
|
|
3312
|
567 syn keyword sqlKeyword referencing regex regexp regexp_substr relative relocate
|
|
4437
|
568 syn keyword sqlKeyword rename repeatable repeatableread replicate replication
|
|
3312
|
569 syn keyword sqlKeyword requests request_timeout required rereceive resend reserve reset
|
|
|
570 syn keyword sqlKeyword resizing resolve resource respect restart
|
|
4437
|
571 syn keyword sqlKeyword restrict result retain retries
|
|
|
572 syn keyword sqlKeyword returns reverse right role roles
|
|
|
573 syn keyword sqlKeyword rollup root row row_number rowlock rows rowtype
|
|
2034
|
574 syn keyword sqlKeyword sa_index_hash sa_internal_fk_verify sa_internal_termbreak
|
|
|
575 syn keyword sqlKeyword sa_order_preserving_hash sa_order_preserving_hash_big sa_order_preserving_hash_prefix
|
|
4437
|
576 syn keyword sqlKeyword sa_file_free_pages sa_internal_type_from_catalog sa_internal_valid_hash
|
|
|
577 syn keyword sqlKeyword sa_internal_validate_value sa_json_element
|
|
|
578 syn keyword sqlKeyword scale schedule schema scope script scripted scroll search seconds secqty security
|
|
3312
|
579 syn keyword sqlKeyword semi send sensitive sent sequence serializable
|
|
4437
|
580 syn keyword sqlKeyword server severity session set_bit set_bits sets
|
|
3312
|
581 syn keyword sqlKeyword shapefile share side simple since site size skip
|
|
4437
|
582 syn keyword sqlKeyword snap snapshot soapheader soap_header
|
|
3312
|
583 syn keyword sqlKeyword spatial split some sorted_data
|
|
|
584 syn keyword sqlKeyword sql sqlcode sqlid sqlflagger sqlstate sqrt square
|
|
4437
|
585 syn keyword sqlKeyword stacker stale state statement statistics status stddev_pop stddev_samp
|
|
3312
|
586 syn keyword sqlKeyword stemmer stogroup stoplist storage store
|
|
2034
|
587 syn keyword sqlKeyword strip stripesizekb striping subpages subscribe subscription
|
|
4437
|
588 syn keyword sqlKeyword subtransaction suser_id suser_name suspend synchronization
|
|
3312
|
589 syn keyword sqlKeyword syntax_error table tables tablock
|
|
4437
|
590 syn keyword sqlKeyword tablockx target tb temp template temporary term then ties
|
|
|
591 syn keyword sqlKeyword timezone timeout tls to to_char to_nchar tolerance top
|
|
|
592 syn keyword sqlKeyword trace traced_plan tracing
|
|
|
593 syn keyword sqlKeyword transfer transform transaction transactional treat tries
|
|
|
594 syn keyword sqlKeyword true try tsequal type tune uncommitted unconditionally
|
|
3312
|
595 syn keyword sqlKeyword unenforced unicode unique unistr unit unknown unlimited unload
|
|
2034
|
596 syn keyword sqlKeyword unpartition unquiesce updatetime updating updlock upgrade upload
|
|
3312
|
597 syn keyword sqlKeyword upper usage use user
|
|
1621
|
598 syn keyword sqlKeyword using utc utilities validproc
|
|
|
599 syn keyword sqlKeyword value values varchar variable
|
|
3312
|
600 syn keyword sqlKeyword varying var_pop var_samp vcat verbosity
|
|
|
601 syn keyword sqlKeyword verify versions view virtual wait
|
|
|
602 syn keyword sqlKeyword warning wd web when where with with_auto
|
|
1621
|
603 syn keyword sqlKeyword with_auto with_cube with_rollup without
|
|
2034
|
604 syn keyword sqlKeyword with_lparen within word work workload write writefile
|
|
4437
|
605 syn keyword sqlKeyword writeclientfile writer writers writeserver xlock
|
|
|
606 syn keyword sqlKeyword war xml zeros zone
|
|
|
607 " XML
|
|
1621
|
608 syn keyword sqlKeyword raw auto elements explicit
|
|
719
|
609 " HTTP support
|
|
2034
|
610 syn keyword sqlKeyword authorization secure url service next_soap_header
|
|
719
|
611 " HTTP 9.0.2 new procedure keywords
|
|
4437
|
612 syn keyword sqlKeyword namespace certificate certificates clientport proxy trusted_certificates_file
|
|
719
|
613 " OLAP support 9.0.0
|
|
2034
|
614 syn keyword sqlKeyword covar_pop covar_samp corr regr_slope regr_intercept
|
|
1621
|
615 syn keyword sqlKeyword regr_count regr_r2 regr_avgx regr_avgy
|
|
|
616 syn keyword sqlKeyword regr_sxx regr_syy regr_sxy
|
|
719
|
617
|
|
|
618 " Alternate keywords
|
|
1621
|
619 syn keyword sqlKeyword character dec options proc reference
|
|
2034
|
620 syn keyword sqlKeyword subtrans tran syn keyword
|
|
719
|
621
|
|
4437
|
622 " Login Mode Options
|
|
|
623 syn keyword sqlKeywordLogin standard integrated kerberos LDAPUA
|
|
|
624 syn keyword sqlKeywordLogin cloudadmin mixed
|
|
|
625
|
|
3312
|
626 " Spatial Predicates
|
|
|
627 syn keyword sqlKeyword ST_Contains
|
|
|
628 syn keyword sqlKeyword ST_ContainsFilter
|
|
|
629 syn keyword sqlKeyword ST_CoveredBy
|
|
|
630 syn keyword sqlKeyword ST_CoveredByFilter
|
|
|
631 syn keyword sqlKeyword ST_Covers
|
|
|
632 syn keyword sqlKeyword ST_CoversFilter
|
|
|
633 syn keyword sqlKeyword ST_Crosses
|
|
|
634 syn keyword sqlKeyword ST_Disjoint
|
|
|
635 syn keyword sqlKeyword ST_Equals
|
|
|
636 syn keyword sqlKeyword ST_EqualsFilter
|
|
|
637 syn keyword sqlKeyword ST_Intersects
|
|
|
638 syn keyword sqlKeyword ST_IntersectsFilter
|
|
|
639 syn keyword sqlKeyword ST_IntersectsRect
|
|
|
640 syn keyword sqlKeyword ST_OrderingEquals
|
|
|
641 syn keyword sqlKeyword ST_Overlaps
|
|
|
642 syn keyword sqlKeyword ST_Relate
|
|
|
643 syn keyword sqlKeyword ST_Touches
|
|
|
644 syn keyword sqlKeyword ST_Within
|
|
|
645 syn keyword sqlKeyword ST_WithinFilter
|
|
|
646 " Spatial Set operations
|
|
|
647 syn keyword sqlKeyword ST_Affine
|
|
|
648 syn keyword sqlKeyword ST_Boundary
|
|
|
649 syn keyword sqlKeyword ST_Buffer
|
|
|
650 syn keyword sqlKeyword ST_ConvexHull
|
|
|
651 syn keyword sqlKeyword ST_ConvexHullAggr
|
|
|
652 syn keyword sqlKeyword ST_Difference
|
|
|
653 syn keyword sqlKeyword ST_Intersection
|
|
|
654 syn keyword sqlKeyword ST_IntersectionAggr
|
|
|
655 syn keyword sqlKeyword ST_SymDifference
|
|
|
656 syn keyword sqlKeyword ST_Union
|
|
|
657 syn keyword sqlKeyword ST_UnionAggr
|
|
|
658 " Spatial Bounds
|
|
|
659 syn keyword sqlKeyword ST_Envelope
|
|
|
660 syn keyword sqlKeyword ST_EnvelopeAggr
|
|
|
661 syn keyword sqlKeyword ST_Lat
|
|
|
662 syn keyword sqlKeyword ST_LatMax
|
|
|
663 syn keyword sqlKeyword ST_LatMin
|
|
|
664 syn keyword sqlKeyword ST_Long
|
|
|
665 syn keyword sqlKeyword ST_LongMax
|
|
|
666 syn keyword sqlKeyword ST_LongMin
|
|
|
667 syn keyword sqlKeyword ST_M
|
|
|
668 syn keyword sqlKeyword ST_MMax
|
|
|
669 syn keyword sqlKeyword ST_MMin
|
|
|
670 syn keyword sqlKeyword ST_Point
|
|
|
671 syn keyword sqlKeyword ST_X
|
|
|
672 syn keyword sqlKeyword ST_XMax
|
|
|
673 syn keyword sqlKeyword ST_XMin
|
|
|
674 syn keyword sqlKeyword ST_Y
|
|
|
675 syn keyword sqlKeyword ST_YMax
|
|
|
676 syn keyword sqlKeyword ST_YMin
|
|
|
677 syn keyword sqlKeyword ST_Z
|
|
|
678 syn keyword sqlKeyword ST_ZMax
|
|
|
679 syn keyword sqlKeyword ST_ZMin
|
|
|
680 " Spatial Collection Aggregates
|
|
|
681 syn keyword sqlKeyword ST_GeomCollectionAggr
|
|
|
682 syn keyword sqlKeyword ST_LineStringAggr
|
|
|
683 syn keyword sqlKeyword ST_MultiCurveAggr
|
|
|
684 syn keyword sqlKeyword ST_MultiLineStringAggr
|
|
|
685 syn keyword sqlKeyword ST_MultiPointAggr
|
|
|
686 syn keyword sqlKeyword ST_MultiPolygonAggr
|
|
|
687 syn keyword sqlKeyword ST_MultiSurfaceAggr
|
|
|
688 syn keyword sqlKeyword ST_Perimeter
|
|
|
689 syn keyword sqlKeyword ST_PointOnSurface
|
|
|
690 " Spatial SRS
|
|
|
691 syn keyword sqlKeyword ST_CompareWKT
|
|
|
692 syn keyword sqlKeyword ST_FormatWKT
|
|
|
693 syn keyword sqlKeyword ST_ParseWKT
|
|
|
694 syn keyword sqlKeyword ST_TransformGeom
|
|
|
695 syn keyword sqlKeyword ST_GeometryTypeFromBaseType
|
|
|
696 syn keyword sqlKeyword ST_SnapToGrid
|
|
|
697 syn keyword sqlKeyword ST_Transform
|
|
|
698 syn keyword sqlKeyword ST_SRID
|
|
|
699 syn keyword sqlKeyword ST_SRIDFromBaseType
|
|
|
700 syn keyword sqlKeyword ST_LoadConfigurationData
|
|
|
701 " Spatial Indexes
|
|
|
702 syn keyword sqlKeyword ST_LinearHash
|
|
|
703 syn keyword sqlKeyword ST_LinearUnHash
|
|
719
|
704
|
|
1621
|
705 syn keyword sqlOperator in any some all between exists
|
|
2034
|
706 syn keyword sqlOperator like escape not is and or
|
|
3312
|
707 syn keyword sqlOperator minus
|
|
4437
|
708 syn keyword sqlOperator prior distinct unnest
|
|
719
|
709
|
|
4437
|
710 syn keyword sqlStatement allocate alter attach backup begin break call case catch
|
|
3312
|
711 syn keyword sqlStatement checkpoint clear close comment commit configure connect
|
|
|
712 syn keyword sqlStatement continue create deallocate declare delete describe
|
|
|
713 syn keyword sqlStatement detach disconnect drop except execute exit explain fetch
|
|
719
|
714 syn keyword sqlStatement for forward from get goto grant help if include
|
|
3312
|
715 syn keyword sqlStatement input insert install intersect leave load lock loop
|
|
|
716 syn keyword sqlStatement message open output parameters passthrough
|
|
|
717 syn keyword sqlStatement prepare print put raiserror read readtext refresh release
|
|
719
|
718 syn keyword sqlStatement remote remove reorganize resignal restore resume
|
|
3312
|
719 syn keyword sqlStatement return revoke rollback save savepoint select
|
|
719
|
720 syn keyword sqlStatement set setuser signal start stop synchronize
|
|
4437
|
721 syn keyword sqlStatement system trigger truncate try union unload update
|
|
3312
|
722 syn keyword sqlStatement validate waitfor whenever while window writetext
|
|
719
|
723
|
|
|
724
|
|
3312
|
725 syn keyword sqlType char nchar long varchar nvarchar text ntext uniqueidentifierstr xml
|
|
|
726 syn keyword sqlType bigint bit decimal double varbit
|
|
|
727 syn keyword sqlType float int integer numeric
|
|
1621
|
728 syn keyword sqlType smallint tinyint real
|
|
|
729 syn keyword sqlType money smallmoney
|
|
3312
|
730 syn keyword sqlType date datetime datetimeoffset smalldatetime time timestamp
|
|
4437
|
731 syn keyword sqlType binary image varray varbinary uniqueidentifier
|
|
3312
|
732 syn keyword sqlType unsigned
|
|
|
733 " Spatial types
|
|
|
734 syn keyword sqlType st_geometry st_point st_curve st_surface st_geomcollection
|
|
|
735 syn keyword sqlType st_linestring st_circularstring st_compoundcurve
|
|
|
736 syn keyword sqlType st_curvepolygon st_polygon
|
|
|
737 syn keyword sqlType st_multipoint st_multicurve st_multisurface
|
|
|
738 syn keyword sqlType st_multilinestring st_multipolygon
|
|
719
|
739
|
|
1621
|
740 syn keyword sqlOption Allow_nulls_by_default
|
|
2034
|
741 syn keyword sqlOption Allow_read_client_file
|
|
|
742 syn keyword sqlOption Allow_snapshot_isolation
|
|
|
743 syn keyword sqlOption Allow_write_client_file
|
|
1621
|
744 syn keyword sqlOption Ansi_blanks
|
|
|
745 syn keyword sqlOption Ansi_close_cursors_on_rollback
|
|
|
746 syn keyword sqlOption Ansi_permissions
|
|
2034
|
747 syn keyword sqlOption Ansi_substring
|
|
1621
|
748 syn keyword sqlOption Ansi_update_constraints
|
|
|
749 syn keyword sqlOption Ansinull
|
|
|
750 syn keyword sqlOption Auditing
|
|
|
751 syn keyword sqlOption Auditing_options
|
|
4437
|
752 syn keyword sqlOption Auto_commit_on_create_local_temp_index
|
|
1621
|
753 syn keyword sqlOption Background_priority
|
|
|
754 syn keyword sqlOption Blocking
|
|
4437
|
755 syn keyword sqlOption Blocking_others_timeout
|
|
1621
|
756 syn keyword sqlOption Blocking_timeout
|
|
|
757 syn keyword sqlOption Chained
|
|
|
758 syn keyword sqlOption Checkpoint_time
|
|
|
759 syn keyword sqlOption Cis_option
|
|
|
760 syn keyword sqlOption Cis_rowset_size
|
|
|
761 syn keyword sqlOption Close_on_endtrans
|
|
2034
|
762 syn keyword sqlOption Collect_statistics_on_dml_updates
|
|
|
763 syn keyword sqlOption Conn_auditing
|
|
1621
|
764 syn keyword sqlOption Connection_authentication
|
|
|
765 syn keyword sqlOption Continue_after_raiserror
|
|
|
766 syn keyword sqlOption Conversion_error
|
|
|
767 syn keyword sqlOption Cooperative_commit_timeout
|
|
|
768 syn keyword sqlOption Cooperative_commits
|
|
|
769 syn keyword sqlOption Database_authentication
|
|
|
770 syn keyword sqlOption Date_format
|
|
|
771 syn keyword sqlOption Date_order
|
|
4437
|
772 syn keyword sqlOption db_publisher
|
|
1621
|
773 syn keyword sqlOption Debug_messages
|
|
|
774 syn keyword sqlOption Dedicated_task
|
|
2034
|
775 syn keyword sqlOption Default_dbspace
|
|
1621
|
776 syn keyword sqlOption Default_timestamp_increment
|
|
|
777 syn keyword sqlOption Delayed_commit_timeout
|
|
|
778 syn keyword sqlOption Delayed_commits
|
|
3312
|
779 syn keyword sqlOption Divide_by_zero_error
|
|
1621
|
780 syn keyword sqlOption Escape_character
|
|
|
781 syn keyword sqlOption Exclude_operators
|
|
|
782 syn keyword sqlOption Extended_join_syntax
|
|
4437
|
783 syn keyword sqlOption Extern_login_credentials
|
|
1621
|
784 syn keyword sqlOption Fire_triggers
|
|
|
785 syn keyword sqlOption First_day_of_week
|
|
|
786 syn keyword sqlOption For_xml_null_treatment
|
|
|
787 syn keyword sqlOption Force_view_creation
|
|
|
788 syn keyword sqlOption Global_database_id
|
|
2034
|
789 syn keyword sqlOption Http_session_timeout
|
|
4437
|
790 syn keyword sqlOption Http_connection_pool_basesize
|
|
|
791 syn keyword sqlOption Http_connection_pool_timeout
|
|
1621
|
792 syn keyword sqlOption Integrated_server_name
|
|
|
793 syn keyword sqlOption Isolation_level
|
|
4437
|
794 syn keyword sqlOption Java_class_path
|
|
2034
|
795 syn keyword sqlOption Java_location
|
|
|
796 syn keyword sqlOption Java_main_userid
|
|
|
797 syn keyword sqlOption Java_vm_options
|
|
1621
|
798 syn keyword sqlOption Lock_rejected_rows
|
|
|
799 syn keyword sqlOption Log_deadlocks
|
|
|
800 syn keyword sqlOption Login_mode
|
|
|
801 syn keyword sqlOption Login_procedure
|
|
2034
|
802 syn keyword sqlOption Materialized_view_optimization
|
|
|
803 syn keyword sqlOption Max_client_statements_cached
|
|
1621
|
804 syn keyword sqlOption Max_cursor_count
|
|
|
805 syn keyword sqlOption Max_hash_size
|
|
|
806 syn keyword sqlOption Max_plans_cached
|
|
2034
|
807 syn keyword sqlOption Max_priority
|
|
|
808 syn keyword sqlOption Max_query_tasks
|
|
1621
|
809 syn keyword sqlOption Max_recursive_iterations
|
|
|
810 syn keyword sqlOption Max_statement_count
|
|
2034
|
811 syn keyword sqlOption Max_temp_space
|
|
1621
|
812 syn keyword sqlOption Min_password_length
|
|
4437
|
813 syn keyword sqlOption Min_role_admins
|
|
1621
|
814 syn keyword sqlOption Nearest_century
|
|
|
815 syn keyword sqlOption Non_keywords
|
|
2034
|
816 syn keyword sqlOption Odbc_describe_binary_as_varbinary
|
|
|
817 syn keyword sqlOption Odbc_distinguish_char_and_varchar
|
|
|
818 syn keyword sqlOption Oem_string
|
|
|
819 syn keyword sqlOption On_charset_conversion_failure
|
|
1621
|
820 syn keyword sqlOption On_tsql_error
|
|
|
821 syn keyword sqlOption Optimization_goal
|
|
|
822 syn keyword sqlOption Optimization_level
|
|
|
823 syn keyword sqlOption Optimization_workload
|
|
|
824 syn keyword sqlOption Pinned_cursor_percent_of_cache
|
|
2034
|
825 syn keyword sqlOption Post_login_procedure
|
|
1621
|
826 syn keyword sqlOption Precision
|
|
|
827 syn keyword sqlOption Prefetch
|
|
|
828 syn keyword sqlOption Preserve_source_format
|
|
|
829 syn keyword sqlOption Prevent_article_pkey_update
|
|
2034
|
830 syn keyword sqlOption Priority
|
|
4437
|
831 syn keyword sqlOption Progress_messages
|
|
2034
|
832 syn keyword sqlOption Query_mem_timeout
|
|
1621
|
833 syn keyword sqlOption Quoted_identifier
|
|
|
834 syn keyword sqlOption Read_past_deleted
|
|
|
835 syn keyword sqlOption Recovery_time
|
|
|
836 syn keyword sqlOption Remote_idle_timeout
|
|
|
837 syn keyword sqlOption Replicate_all
|
|
2034
|
838 syn keyword sqlOption Request_timeout
|
|
4437
|
839 syn keyword sqlOption Reserved_keywords
|
|
1621
|
840 syn keyword sqlOption Return_date_time_as_string
|
|
|
841 syn keyword sqlOption Rollback_on_deadlock
|
|
|
842 syn keyword sqlOption Row_counts
|
|
|
843 syn keyword sqlOption Scale
|
|
2034
|
844 syn keyword sqlOption Secure_feature_key
|
|
|
845 syn keyword sqlOption Sort_collation
|
|
|
846 syn keyword sqlOption Sql_flagger_error_level
|
|
|
847 syn keyword sqlOption Sql_flagger_warning_level
|
|
1621
|
848 syn keyword sqlOption String_rtruncation
|
|
4437
|
849 syn keyword sqlOption st_geometry_asbinary_format
|
|
|
850 syn keyword sqlOption st_geometry_astext_format
|
|
|
851 syn keyword sqlOption st_geometry_asxml_format
|
|
|
852 syn keyword sqlOption st_geometry_describe_type
|
|
|
853 syn keyword sqlOption st_geometry_interpolation
|
|
|
854 syn keyword sqlOption st_geometry_on_invalid
|
|
1621
|
855 syn keyword sqlOption Subsume_row_locks
|
|
2034
|
856 syn keyword sqlOption Suppress_tds_debugging
|
|
|
857 syn keyword sqlOption Synchronize_mirror_on_commit
|
|
|
858 syn keyword sqlOption Tds_empty_string_is_null
|
|
1621
|
859 syn keyword sqlOption Temp_space_limit_check
|
|
|
860 syn keyword sqlOption Time_format
|
|
|
861 syn keyword sqlOption Time_zone_adjustment
|
|
|
862 syn keyword sqlOption Timestamp_format
|
|
4437
|
863 syn keyword sqlOption Timestamp_with_time_zone_format
|
|
1621
|
864 syn keyword sqlOption Truncate_timestamp_values
|
|
2034
|
865 syn keyword sqlOption Tsql_outer_joins
|
|
1621
|
866 syn keyword sqlOption Tsql_variables
|
|
2034
|
867 syn keyword sqlOption Updatable_statement_isolation
|
|
1621
|
868 syn keyword sqlOption Update_statistics
|
|
2034
|
869 syn keyword sqlOption Upgrade_database_capability
|
|
1621
|
870 syn keyword sqlOption User_estimates
|
|
3312
|
871 syn keyword sqlOption Uuid_has_hyphens
|
|
2034
|
872 syn keyword sqlOption Verify_password_function
|
|
1621
|
873 syn keyword sqlOption Wait_for_commit
|
|
2034
|
874 syn keyword sqlOption Webservice_namespace_host
|
|
4437
|
875 syn keyword sqlOption Webservice_sessionid_name
|
|
719
|
876
|
|
|
877 " Strings and characters:
|
|
|
878 syn region sqlString start=+"+ end=+"+ contains=@Spell
|
|
|
879 syn region sqlString start=+'+ end=+'+ contains=@Spell
|
|
|
880
|
|
|
881 " Numbers:
|
|
|
882 syn match sqlNumber "-\=\<\d*\.\=[0-9_]\>"
|
|
|
883
|
|
|
884 " Comments:
|
|
|
885 syn region sqlDashComment start=/--/ end=/$/ contains=@Spell
|
|
|
886 syn region sqlSlashComment start=/\/\// end=/$/ contains=@Spell
|
|
|
887 syn region sqlMultiComment start="/\*" end="\*/" contains=sqlMultiComment,@Spell
|
|
|
888 syn cluster sqlComment contains=sqlDashComment,sqlSlashComment,sqlMultiComment,@Spell
|
|
|
889 syn sync ccomment sqlComment
|
|
|
890 syn sync ccomment sqlDashComment
|
|
|
891 syn sync ccomment sqlSlashComment
|
|
|
892
|
|
4437
|
893 hi def link sqlDashComment Comment
|
|
|
894 hi def link sqlSlashComment Comment
|
|
|
895 hi def link sqlMultiComment Comment
|
|
|
896 hi def link sqlNumber Number
|
|
|
897 hi def link sqlOperator Operator
|
|
|
898 hi def link sqlSpecial Special
|
|
|
899 hi def link sqlKeyword Keyword
|
|
|
900 hi def link sqlStatement Statement
|
|
|
901 hi def link sqlString String
|
|
|
902 hi def link sqlType Type
|
|
|
903 hi def link sqlFunction Function
|
|
|
904 hi def link sqlOption PreProc
|
|
719
|
905
|
|
|
906 let b:current_syntax = "sqlanywhere"
|
|
|
907
|
|
1621
|
908 " vim:sw=4:
|
