Or try:
.mode lines
.null <NULL>
select * from tablename limit 1;
The output is more readable if tablename has many columns and also provides
some example data for each column.
rayB
|---------+----------------------------------->
| | "Griggs, Donald" |
| | <[EMAIL PROTECTED]|
| | thcare.com> |
| | |
| | 27/08/2004 07:41 |
| | Please respond to |
| | sqlite-users |
| | |
|---------+----------------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: RE: [sqlite] How can i get the column's names from a table with t
he sqlite.exe command line ? |
>------------------------------------------------------------------------------------------------------------------------------|
Subject: [sqlite] How can i get the column's names from a table with the
sqlite.exe command line ?
Bonjours, Christian.
As far as I know, you could either:
Parse them from the output of
.schema tablename
or, more simply, if the table is non-empty:
.headers on
select * from tablename limit 1;
and pay attention to only the first of the two lines of output (the
headers)
Opinions are not necessarily those of Misys Healthcare Systems nor its
board
of directors.
******************* Confidentiality and Privilege Notice *******************
This e-mail is intended only to be read or used by the addressee. It is
confidential and may contain legally privileged information. If you are not
the addressee indicated in this message (or responsible for delivery of the
message to such person), you may not copy or deliver this message to anyone,
and you should destroy this message and kindly notify the sender by reply
e-mail. Confidentiality and legal privilege are not waived or lost by reason
of mistaken delivery to you.
Qantas Airways Limited
ABN 16 009 661 901
Visit Qantas online at http://qantas.com
****************************************************************************
