DOKK / manpages / debian 10 / grass-doc / db.droptable.1grass.en
db.droptable(1grass) Grass User's Manual db.droptable(1grass)

db.droptable - Drops an attribute table.

database, attribute table

db.droptable
db.droptable --help
db.droptable [-f] [driver=name] [database=name] table=name [--help] [--verbose] [--quiet] [--ui]


Force removal (required for actual deletion of files)

Print usage summary

Verbose module output

Quiet module output

Force launching GUI dialog


Name of database driver
If not given then default driver is used

Name of database
If not given then default database is used

Name of table to drop

db.droptable drops an attribute table. If the -f force flag is not given then nothing is removed, instead a preview of the action to be taken is printed.

db.droptable is a front-end to db.execute to allow easier usage. To some extent it is verified if the table is connected to a vector map to avoid accidental table removal.

# show default database
db.connect -p
# show available tables
db.tables -p
# this will show what would happen
db.droptable table=sometable
# actually drop the table
db.droptable -f table=sometable

db.droptable allows defining optionally driver and database options different from default connection settings (db.connect -p). 

# drop the table from SQLite database
db.droptable -f table=sometable driver=sqlite database=/opt/sqlite.db

db.dropdb, db.dropcolumn, db.execute, db.login, db.connect, db.tables, db.describe, v.db.droptable,

GRASS SQL interface

Markus Neteler
Driver and database options added by Martin Landa, Czech Technical University in Prague, Czech Republic

Last changed: $Date: 2016-09-19 11:37:30 +0200 (Mon, 19 Sep 2016) $

Available at: db.droptable source code (history)

Main index | Database index | Topics index | Keywords index | Graphical index | Full index

© 2003-2019 GRASS Development Team, GRASS GIS 7.6.0 Reference Manual

GRASS 7.6.0