Home Explore Blog CI



neovim

10th chunk of `runtime/doc/ft_sql.txt`
733444f53f8d9fe333e8efba8b9730608db382f6431b964f000000010000092f
 been described in other sections of this document in
greater detail.  Here is a list of the maps with a brief description of each.

Static Maps ~

These are maps which use populate the completion list using Vim's syntax
highlighting rules. >
    <C-C>a
<       - Displays all SQL syntax items. >
    <C-C>k
<       - Displays all SQL syntax items defined as 'sqlKeyword'. >
    <C-C>f
<       - Displays all SQL syntax items defined as 'sqlFunction. >
    <C-C>o
<       - Displays all SQL syntax items defined as 'sqlOption'. >
    <C-C>T
<       - Displays all SQL syntax items defined as 'sqlType'. >
    <C-C>s
<       - Displays all SQL syntax items defined as 'sqlStatement'. >

Dynamic Maps ~

These are maps which use populate the completion list using the dbext.vim
plugin. >
    <C-C>t
<       - Displays a list of tables. >
    <C-C>p
<       - Displays a list of procedures. >
    <C-C>v
<       - Displays a list of views. >
    <C-C>c
<       - Displays a list of columns for a specific table. >
    <C-C>l
<       - Displays a comma-separated list of columns for a specific table. >
    <C-C>L
<       - Displays a comma-separated list of columns for a specific table.
	  This should only be used when the completion window is active. >
    <Right>
<	- Displays a list of columns for the table currently highlighted in
	  the completion window.  <Right> is not recognized on most Unix
	  systems, so this maps is only created on the Windows platform.
	  If you would like the same feature on Unix, choose a different key
	  and make the same map in your vimrc. >
    <Left>
<	- Displays the list of tables.
	  <Left> is not recognized on most Unix systems, so this maps is
	  only created on the Windows platform.  If you would like the same
	  feature on Unix, choose a different key and make the same map in
	  your vimrc. >
    <C-C>R
<	- This maps removes all cached items and forces the SQL completion
	  to regenerate the list of items.

Customizing Maps ~

You can create as many additional key maps as you like.  Generally, the maps
will be specifying different syntax highlight groups.

If you do not wish the default maps created or the key choices do not work on
your platform (often a case on unix) you define the following variable in
your |init.vim|: >
    let g:omni_sql_no_default_maps = 1

Do not edit ftplugin/sql.vim

Title: SQL Completion Maps: Static and Dynamic
Summary
This section details the default SQL completion maps, dividing them into static maps (using Vim's syntax highlighting for SQL syntax items like keywords, functions, options, types, and statements) and dynamic maps (using the dbext.vim plugin for tables, procedures, views, and columns). It also describes column list maps, platform-specific maps for navigating tables and columns, and a map to refresh the cached completion list. The section concludes with information on customizing maps and disabling default maps by setting `g:omni_sql_no_default_maps = 1` in your `init.vim`.