Mercurial > vim

comparison runtime/doc/ft_sql.txt @ 28379:6dd88e45d47d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Update runtime files Commit: https://github.com/vim/vim/commit/cbaff5e06ec525d31dc44093125c42029e01d508 Author: Bram Moolenaar <Bram@vim.org> Date: Fri Apr 8 17:45:08 2022 +0100 Update runtime files
author Bram Moolenaar <Bram@vim.org>
date Fri, 08 Apr 2022 19:00:04 +0200
parents d19b7aee1925
children f8116058ca76
comparison
equal deleted inserted replaced
28378:b8d39e361293 28379:6dd88e45d47d
1 *ft_sql.txt* For Vim version 8.2. Last change: 2019 Dec 07 1 *ft_sql.txt* For Vim version 8.2. Last change: 2022 Apr 06
2 2
3 by David Fishburn 3 by David Fishburn
4 4
5 This is a filetype plugin to work with SQL files. 5 This is a filetype plugin to work with SQL files.
6 6
557 6. Repeat step 5 as often as necessary. > 557 6. Repeat step 5 as often as necessary. >
558 All columns for a table: 558 All columns for a table:
559 < 1. After typing SELECT press <C-C>t to display a list of tables. 559 < 1. After typing SELECT press <C-C>t to display a list of tables.
560 2. Highlight the table you need the column list for. 560 2. Highlight the table you need the column list for.
561 3. Press <Enter> to choose the table from the list. 561 3. Press <Enter> to choose the table from the list.
562 4. Press <C-C>l to request a comma separated list of all columns 562 4. Press <C-C>l to request a comma-separated list of all columns
563 for this table. 563 for this table.
564 5. Based on the table name chosen in step 3, the plugin attempts to 564 5. Based on the table name chosen in step 3, the plugin attempts to
565 decide on a reasonable table alias. You are then prompted to 565 decide on a reasonable table alias. You are then prompted to
566 either accept of change the alias. Press OK. 566 either accept of change the alias. Press OK.
567 6. The table name is replaced with the column list of the table is 567 6. The table name is replaced with the column list of the table is
611 - If this variable is defined, no maps are created for OMNI 611 - If this variable is defined, no maps are created for OMNI
612 completion. See |sql-completion-maps| for further discussion. 612 completion. See |sql-completion-maps| for further discussion.
613 > 613 >
614 omni_sql_use_tbl_alias 614 omni_sql_use_tbl_alias
615 < - Default: a 615 < - Default: a
616 - This setting is only used when generating a comma separated 616 - This setting is only used when generating a comma-separated
617 column list. By default the map is <C-C>l. When generating 617 column list. By default the map is <C-C>l. When generating
618 a column list, an alias can be prepended to the beginning of each 618 a column list, an alias can be prepended to the beginning of each
619 column, for example: e.emp_id, e.emp_name. This option has three 619 column, for example: e.emp_id, e.emp_name. This option has three
620 settings: > 620 settings: >
621 n - do not use an alias 621 n - do not use an alias
695 <C-C>v 695 <C-C>v
696 < - Displays a list of views. > 696 < - Displays a list of views. >
697 <C-C>c 697 <C-C>c
698 < - Displays a list of columns for a specific table. > 698 < - Displays a list of columns for a specific table. >
699 <C-C>l 699 <C-C>l
700 < - Displays a comma separated list of columns for a specific table. > 700 < - Displays a comma-separated list of columns for a specific table. >
701 <C-C>L 701 <C-C>L
702 < - Displays a comma separated list of columns for a specific table. 702 < - Displays a comma-separated list of columns for a specific table.
703 This should only be used when the completion window is active. > 703 This should only be used when the completion window is active. >
704 <Right> 704 <Right>
705 < - Displays a list of columns for the table currently highlighted in 705 < - Displays a list of columns for the table currently highlighted in
706 the completion window. <Right> is not recognized on most Unix 706 the completion window. <Right> is not recognized on most Unix
707 systems, so this maps is only created on the Windows platform. 707 systems, so this maps is only created on the Windows platform.