[GRASSLIST:7259] Re: db.droptable

David Finlayson david.p.finlayson at gmail.com
Tue Jun 21 13:58:40 EDT 2005

I have been learning the GRASS SQL commands and don't fully understand
why there are individual commands for some SQL statements and not
others (for example why not just have db.execute?). In fact, I have
found some SELECT statements don't work in db.execute but do work in
db.select. This seems a bit confusing to me.


On 6/21/05, Moritz Lennert <mlennert at club.worldonline.be> wrote:
> On Tue, June 21, 2005 18:40, Aldo Clerici said:
> > Dear GRASSusers,
> > does it exist the db.droptable command?
> > It is described in the GRASS GIS Reference Manual and in many tutorials, but
> > it seems not to exist in my GRASS version (6.1.cvs).
> Currently it does not exist. The recommended way of dropping a table is:
> echo "DROP TABLE fmacopy" | db.execute
> However, it wouldn't be too difficult to create a db.droptable if there is
> real demand.
> Moritz

David Finlayson
Marine Geology & Geophysics
School of Oceanography
Box 357940
University of Washington
Seattle, WA  98195-7940

Office: Marine Sciences Building, Room 112
Phone: (206) 616-9407
Web: http://students.washington.edu/dfinlays

More information about the grass-user mailing list