Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

With the mysql shell, you can get vertical output when executing interactive queries by ending them with \G instead of ;.

For example:

mysql> select * from foo limit 1\G
*************************** 1. row ***************************
      sid: foo
    login: bar
1 row in set (0.00 sec)

Is it possible to do the same using fisql from FreeTDS?

Alternatively, I will accept an answer that can recommend a better UNIX-compatible command line interface to SQL Server that has this capability.


share|improve this question
up vote 2 down vote accepted

I just discovered sqsh which seems to do the trick:

$ sqsh -S server:1433 -U sa  
sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray
This is free software with ABSOLUTELY NO WARRANTY
For more information type '\warranty'
1> select * from sys.databases where name = 'master'
2> go -m vert
name:                           master
database_id:                    1
source_database_id:             NULL
owner_sid:                      0x01

(1 row affected)
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.