GRASS GIS manual: db.dropcolumn

Note: A new GRASS GIS stable version has been released: GRASS GIS 7.4, 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

DESCRIPTION
NOTES
EXAMPLE
SEE ALSO
AUTHOR

DESCRIPTION

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.

NOTES

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.

EXAMPLE

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

AUTHOR

Markus Neteler

Last changed: $Date: 2011-11-08 13:24:20 -0800 (Tue, 08 Nov 2011) $

SOURCE CODE

Available at: db.dropcolumn source code (history)