Fandom

Vim Tips Wiki

Describe a SQL table from Vim

Redirected from VimTip156

1,624pages on
this wiki
Add New Page
Talk0 Share

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.

Tip 156 Printable Monobook Previous Next

created November 7, 2001 · complexity basic · author Demian L. Neidetcher · version 5.7


Here is a bash script to call from Vim, when you want information about a table while you are editing SQL code. Put the script in a file named describe.

#!/usr/bin/bash

f=aTempFile.sql
u=<uName>
p=<pWord>
d=<dBase>

echo "/* describe for $1"
echo "describe $1;" > $f;
echo "quit;" >> $f;

sqlplus -S $u/$p@$d @$f
rm -f $f;
echo " end describe for $1 */"

Your path needs to include the script (as well as sqlplus), then from Vim you type:

:r !describe <tableName>

That inserts a listing of the table columns, complete with Java/C comments.

CommentsEdit

Also on Fandom

Random Wiki