db.droptable.1grass - Man Page

Drops an attribute table.

Keywords

database, attribute table

Synopsis

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

Flags

-f: Force removal (required for actual deletion of files)
--help: Print usage summary
--verbose: Verbose module output
--quiet: Quiet module output
--ui: Force launching GUI dialog

Parameters

driver=name: Name of database driver
If not given then default driver is used
database=name: Name of database
If not given then default database is used
table=nameÂ [required]: Name of table to drop

Description

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.

Notes

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.

Examples

Removing an attribute table from default database

# 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

Removing an attribute table from given database

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

Authors

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

Source Code

Available at: db.droptable source code (history)

Accessed: Monday Sep 09 08:49:52 2024

Info

GRASS 8.4.0 GRASS GIS User's Manual