Note: A new GRASS GIS stable version has been released: GRASS GIS 7.8, available here.
Updated manual page: here
NAME
db.dropcolumn - Drops a column from selected attribute table.
KEYWORDS
database,
attribute table
SYNOPSIS
db.dropcolumn
db.dropcolumn --help
db.dropcolumn [-f] table=name column=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:
- table=name [required]
- Name of attribute table
- column=name [required]
- 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$
SOURCE CODE
Available at: db.dropcolumn source code (history)
Note: A new GRASS GIS stable version has been released: GRASS GIS 7.8, available here.
Updated manual page: here
Main index |
Database index |
Topics index |
Keywords index |
Graphical index |
Full index
© 2003-2020
GRASS Development Team,
GRASS GIS 7.6.2dev Reference Manual