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

db.dropcolumn - Drops a column from selected attribute table.

database, attribute table

db.dropcolumn
db.dropcolumn --help
db.dropcolumn [-f] table=name column=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 attribute table

Name of attribute column

db.dropcolumn drops a column from 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.dropcolumn is a front-end to db.execute to allow easier usage with a special workaround for the SQLite driver to support column drop also for SQLite tables.

Dropping a column (North Carolina sample dataset):

# work on own copy
g.copy vect=roadsmajor,myroads
db.describe -c myroads
# only shows what would happen:
db.dropcolumn myroads column=SHAPE_LEN
# actually drops the column
db.dropcolumn -f myroads column=SHAPE_LEN
db.describe -c myroads

db.describe, db.droptable, db.execute, v.db.dropcolumn, GRASS SQL interface

Markus Neteler

Last changed: $Date: 2011-11-08 22:24:20 +0100 (Tue, 08 Nov 2011) $

Available at: db.dropcolumn 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