SQL .mode column command

Check or uncheck View > Show/Hide > SQL to toggle the visibility of the SQL Control Bar.

.mode column command

The ".mode" command is used to switch between the output formats shown above. Here is an example:

Use an overlay named Mastermap.gz to find Items with a feature code of 10172 and create a csv file of the found item values enter the following at the SQL> prompt:

.mode column
select * from "Mastermap.gz" where featurecode=10172;

The above is an example of a default listing. To adjust the column width or turn on headings, for example

.width 20 20 20 20 20 20

will set the first six column widths to 20 characters.

---