SQL .mode copy command

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

.mode copy command

The ".mode" command is used to switch between the output formats shown above.

This is an example of the .mode copy command.

Use an overlay named Mastermap.gz to add Items with a feature code of 10172 to a new internal dataset enter the following at the SQL> prompt:

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

Untitled 1 is the new internal dataset created by .mode copy.

---