Announcing an update to the sqlcomplete.vim script which is included in Vim7. If you are using dbext.vim 3.0 and taking advantage of the table and column completion capabilities the update to version 5.0 of the script makes it a bit smarter when determine if you are entering partial column names or tables names along with owner/creator features.
Read on for more details if you are not already using it. Enjoy. Dave http://www.vim.org/scripts/script.php?script_id=1572 SQLComplete.vim : SQLComplete is a SQL code completion system using the omnifunc framework description SQLComplete.vim is a plugin which uses the new Vim7 OMNI completion features (intellisense code completion). SQLComplete.vim version 4.0 is included in the Vim 7.0 release. What does it do: ----------------------- Completion for the SQL language includes statements, functions, keywords, operators and database options which it draws from the current SQL syntax file in use. Vim ships with 9 different SQL syntax files (Oracle, Informix, MySQL, SQL Anywhere, ...). It will also dynamically complete tables, procedures, views and column lists with data pulled directly from within a database. It does this in conjunction with the dbext.vim "vimscript #356". For detailed instructions and a tutorial see |omni-sql-completion|. Existing instructions can be found within Vim7 using :h sql.txt :h sql-completion This plugin is new to Vim7. Improvements to the script will be uploaded here, and supplied to Bram for inclusion into future versions of Vim7. install details Copy sqlcomplete.vim to: .vim/autoload/sqlcomplete.vim (Unix) vimfiles\autoload\sqlcomplete.vim (Windows) For documentation: :h sql.txt