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