1db.droptable(1) GRASS GIS User's Manual db.droptable(1)
2
3
4
6 db.droptable - Drops an attribute table.
7
9 database, attribute table
10
12 db.droptable
13 db.droptable --help
14 db.droptable [-f] [driver=name] [database=name] table=name
15 [--help] [--verbose] [--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 driver=name
35 Name of database driver
36 If not given then default driver is used
37
38 database=name
39 Name of database
40 If not given then default database is used
41
42 table=name [required]
43 Name of table to drop
44
46 db.droptable drops an attribute table. If the -f force flag is not
47 given then nothing is removed, instead a preview of the action to be
48 taken is printed.
49
51 db.droptable is a front-end to db.execute to allow easier usage. To
52 some extent it is verified if the table is connected to a vector map to
53 avoid accidental table removal.
54
56 Removing an attribute table from default database
57 # show default database
58 db.connect -p
59 # show available tables
60 db.tables -p
61 # this will show what would happen
62 db.droptable table=sometable
63 # actually drop the table
64 db.droptable -f table=sometable
65
66 Removing an attribute table from given database
67 db.droptable allows defining optionally driver and database options
68 different from default connection settings (db.connect -p).
69 # drop the table from SQLite database
70 db.droptable -f table=sometable driver=sqlite database=/opt/sqlite.db
71
73 db.dropdb, db.dropcolumn, db.execute, db.login, db.connect, db.tables,
74 db.describe, v.db.droptable,
75
76 GRASS SQL interface
77
79 Markus Neteler
80 Driver and database options added by Martin Landa, Czech Technical Uni‐
81 versity in Prague, Czech Republic
82
84 Available at: db.droptable source code (history)
85
86 Accessed: Mon Jun 20 16:47:44 2022
87
88 Main index | Database index | Topics index | Keywords index | Graphical
89 index | Full index
90
91 © 2003-2022 GRASS Development Team, GRASS GIS 8.2.0 Reference Manual
92
93
94
95GRASS 8.2.0 db.droptable(1)