1db.dropcolumn(1)            GRASS GIS User's Manual           db.dropcolumn(1)
2
3
4

NAME

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

KEYWORDS

9       database, attribute table
10

SYNOPSIS

12       db.dropcolumn
13       db.dropcolumn --help
14       db.dropcolumn   [-f]   table=name  column=name   [--help]   [--verbose]
15       [--quiet]  [--ui]
16
17   Flags:
18       -f
19           Force removal (required for actual deletion of files)
20
21       --help
22           Print usage summary
23
24       --verbose
25           Verbose module output
26
27       --quiet
28           Quiet module output
29
30       --ui
31           Force launching GUI dialog
32
33   Parameters:
34       table=name [required]
35           Name of attribute table
36
37       column=name [required]
38           Name of attribute column
39

DESCRIPTION

41       db.dropcolumn drops a column from an attribute table.  If the -f  force
42       flag is not given then nothing is removed, instead a preview of the ac‐
43       tion to be taken is printed.
44

NOTES

46       db.dropcolumn is a front-end to db.execute to allow easier usage with a
47       special  workaround  for  the SQLite driver to support column drop also
48       for SQLite tables.
49

EXAMPLE

51       Dropping a column (North Carolina sample dataset):
52
53       # work on own copy
54       g.copy vect=roadsmajor,myroads
55       db.describe -c myroads
56       # only shows what would happen:
57       db.dropcolumn myroads column=SHAPE_LEN
58       # actually drops the column
59       db.dropcolumn -f myroads column=SHAPE_LEN
60       db.describe -c myroads
61

SEE ALSO

63        db.describe, db.droptable, db.execute, v.db.dropcolumn, GRASS SQL  in‐
64       terface
65

AUTHOR

67       Markus Neteler
68

SOURCE CODE

70       Available at: db.dropcolumn source code (history)
71
72       Accessed: Saturday Jan 21 20:41:00 2023
73
74       Main index | Database index | Topics index | Keywords index | Graphical
75       index | Full index
76
77       © 2003-2023 GRASS Development Team, GRASS GIS 8.2.1 Reference Manual
78
79
80
81GRASS 8.2.1                                                   db.dropcolumn(1)
Impressum