Mercurial > vim

comparison runtime/doc/ft_sql.txt @ 29450:67f31c24291b

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/b529cfbd04c02e31cfa88f2c8d88b5ff532d4f7d Author: Bram Moolenaar <Bram@vim.org> Date: Mon Jul 25 15:42:07 2022 +0100 Update runtime files
author Bram Moolenaar <Bram@vim.org>
date Mon, 25 Jul 2022 16:45:06 +0200
parents f8116058ca76
children 4635e43f2c6f
comparison
equal deleted inserted replaced
29449:25b27a637e86 29450:67f31c24291b
504 documentation. 504 documentation.
505 505
506 Assuming you have followed the dbext-tutorial you can press <C-C>t to 506 Assuming you have followed the dbext-tutorial you can press <C-C>t to
507 display a list of tables. There is a delay while dbext is creating the table 507 display a list of tables. There is a delay while dbext is creating the table
508 list. After the list is displayed press <C-W>. This will remove both the 508 list. After the list is displayed press <C-W>. This will remove both the
509 popup window and the table name already chosen when the list became active. > 509 popup window and the table name already chosen when the list became active.
510 510
511 4.3.1 Table Completion: *sql-completion-tables* 511 4.3.1 Table Completion: *sql-completion-tables*
512 512
513 Press <C-C>t to display a list of tables from within the database you 513 Press <C-C>t to display a list of tables from within the database you
514 have connected via the dbext plugin. 514 have connected via the dbext plugin.
515 NOTE: All of the SQL completion popups support typing a prefix before pressing 515 NOTE: All of the SQL completion popups support typing a prefix before pressing
516 the key map. This will limit the contents of the popup window to just items 516 the key map. This will limit the contents of the popup window to just items
517 beginning with those characters. > 517 beginning with those characters.
518 518
519 4.3.2 Column Completion: *sql-completion-columns* 519 4.3.2 Column Completion: *sql-completion-columns*
520 520
521 The SQL completion plugin can also display a list of columns for particular 521 The SQL completion plugin can also display a list of columns for particular
522 tables. The column completion is triggered via <C-C>c. 522 tables. The column completion is triggered via <C-C>c.
585 "customer" table, you can press either <C-C>c or <C-X><C-O>. This will 585 "customer" table, you can press either <C-C>c or <C-X><C-O>. This will
586 popup a list of columns for the customer table. It does this by looking back 586 popup a list of columns for the customer table. It does this by looking back
587 to the beginning of the select statement and finding a list of the tables 587 to the beginning of the select statement and finding a list of the tables
588 specified in the FROM clause. In this case it notes that in the string 588 specified in the FROM clause. In this case it notes that in the string
589 "customer c", "c" is an alias for the customer table. The optional "AS" 589 "customer c", "c" is an alias for the customer table. The optional "AS"
590 keyword is also supported, "customer AS c". > 590 keyword is also supported, "customer AS c".
591 591
592 592
593 4.3.3 Procedure Completion: *sql-completion-procedures* 593 4.3.3 Procedure Completion: *sql-completion-procedures*
594 594
595 Similar to the table list, <C-C>p, will display a list of stored 595 Similar to the table list, <C-C>p, will display a list of stored
596 procedures stored within the database. > 596 procedures stored within the database.
597 597
598 4.3.4 View Completion: *sql-completion-views* 598 4.3.4 View Completion: *sql-completion-views*
599 599
600 Similar to the table list, <C-C>v, will display a list of views in the 600 Similar to the table list, <C-C>v, will display a list of views in the
601 database. 601 database.