1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
<h2>DESCRIPTION</h2>
<em>db.dropcolumn</em> drops a column from an attribute table.
If the <b>-f</b> force flag is not given then nothing is removed, instead
a preview of the action to be taken is printed.
<h2>NOTES</h2>
<em>db.dropcolumn</em> is a front-end to <em>db.execute</em> to allow easier
usage with a special workaround for the SQLite driver to support column
drop also for SQLite tables.
<h2>EXAMPLE</h2>
Dropping a column (North Carolina sample dataset):
<p><div class="code"><pre>
# 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
</pre></div>
<h2>SEE ALSO</h2>
<em>
<a href="db.describe.html">db.describe</a>,
<a href="db.droptable.html">db.droptable</a>,
<a href="db.execute.html">db.execute</a>,
<a href="v.db.dropcolumn.html">v.db.dropcolumn</a>,
<a href="sql.html">GRASS SQL interface</a>
</em>
<h2>AUTHOR</h2>
Markus Neteler
|
