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