handy command line client for tds databases

Thu, 08 Jan 2015 08:36:57 +0000

[...]

exec_sql() { echo "$*" | \ bsqldb -q -h -t '|-|' -S "$SERVER" -D "$DATABASE" -U "$USER" -P "$PASSWORD" }

to_html() { echo '

' sed 's#&#\&#g;s#<#\<#g;s#>#\>#g' | \ sed 's#^##;s#|-|#\(

#;s#$#

#g' | \ sed '/

-*<\/td>\)*<\/tr>/{;s#.*#

#p;d;};${;x;p;};x' echo '

' }

while true; do read -p "> "sql> " QUERY exec_sql "$QUERY" | to_html | w3m -dump -T text/html done }}}

[...]

* list all tables in your ~~database (from sysobjects):~~ database: {{{ > sql> sp_tables }}}

* list all kinds of stuff in your database: {{{ sql> select name,type from sysobjects }}}

* show the definition of a table ~~(from~~ (this information comes from syscolumns): {{{ > sql> sp_help tablename }}}

* show the definition of a view, stored procedure or similar ~~(from~~ (this information comes from syscomments): {{{ > sql> sp_helptext viewname }}}

[...]