.TH db.dropcolumn 1grass "" "GRASS 7.8.5" "GRASS GIS User's Manual"
.SH NAME
\fI\fBdb.dropcolumn\fR\fR  \- Drops a column from selected attribute table.
.SH KEYWORDS
database, attribute table
.SH SYNOPSIS
\fBdb.dropcolumn\fR
.br
\fBdb.dropcolumn \-\-help\fR
.br
\fBdb.dropcolumn\fR [\-\fBf\fR] \fBtable\fR=\fIname\fR \fBcolumn\fR=\fIname\fR  [\-\-\fBhelp\fR]  [\-\-\fBverbose\fR]  [\-\-\fBquiet\fR]  [\-\-\fBui\fR]
.SS Flags:
.IP "\fB\-f\fR" 4m
.br
Force removal (required for actual deletion of files)
.IP "\fB\-\-help\fR" 4m
.br
Print usage summary
.IP "\fB\-\-verbose\fR" 4m
.br
Verbose module output
.IP "\fB\-\-quiet\fR" 4m
.br
Quiet module output
.IP "\fB\-\-ui\fR" 4m
.br
Force launching GUI dialog
.SS Parameters:
.IP "\fBtable\fR=\fIname\fR \fB[required]\fR" 4m
.br
Name of attribute table
.IP "\fBcolumn\fR=\fIname\fR \fB[required]\fR" 4m
.br
Name of attribute column
.SH DESCRIPTION
\fIdb.dropcolumn\fR drops a column from an attribute table.
If the \fB\-f\fR force flag is not given then nothing is removed, instead
a preview of the action to be taken is printed.
.SH NOTES
\fIdb.dropcolumn\fR is a front\-end to \fIdb.execute\fR to allow easier
usage with a special workaround for the SQLite driver to support column
drop also for SQLite tables.
.SH EXAMPLE
Dropping a column (North Carolina sample dataset):
.PP
.br
.nf
\fC
# 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
\fR
.fi
.SH SEE ALSO
\fI
db.describe,
db.droptable,
db.execute,
v.db.dropcolumn,
GRASS SQL interface
\fR
.SH AUTHOR
Markus Neteler
.SH SOURCE CODE
.PP
Available at: db.dropcolumn source code (history)
.PP
Main index |
Database index |
Topics index |
Keywords index |
Graphical index |
Full index
.PP
© 2003\-2020
GRASS Development Team,
GRASS GIS 7.8.5 Reference Manual