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

NAME  KEYWORDS  SYNOPSIS  Flags:  Parameters:  DESCRIPTION  NOTES  EXAMPLE  SEE ALSO  AUTHOR  SOURCE CODE 

---

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 [database=name] [driver=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

database=name

Name of database

driver=name

Name of database driver
Options: dbf, odbc, ogr, sqlite, pg

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

SEE ALSO

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

AUTHOR

Markus Neteler

SOURCE CODE

Available at: db.dropcolumn source code (history)

Latest change: Wednesday Feb 28 18:00:11 2024 in commit: d33427c1a144bf2463c7610e45a9f4679b2e9b3e

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

© 2003−2025 GRASS Development Team, GRASS GIS 8.4.1 Reference Manual

---