db.droptable(1grass)

💖 db.droptable — the GRASS manual, but make it slay 💖

okay bestie, so this one is db.droptable from the GRASS User's Manual, and it's literally the girl who deletes stuff for you (only when you tell her to). Let's get into it 🎀

---

✨ NAME ✨

db.droptable — drops an attribute table. that's it, that's the whole job. goodbye table bestie 👋

---

🌈 KEYWORDS 🌈

database, attribute table

---

🦋 SYNOPSIS 🦋

db.droptable
db.droptable --help
db.droptable [-f]  [driver=name]   [database=name]  table=name  [--help]
[--verbose]  [--quiet]  [--ui]

🚩 Flags:

• -f — the force flag. this is the one that actually lets files get deleted. without it, nothing happens. respect the -f, fr fr
• --help — prints the usage summary so you're not out here guessing 💅
• --verbose — verbose module output, i.e. she tells you everything
• --quiet — quiet module output, i.e. she says nothing, mysterious queen
• --ui — forces the GUI dialog to launch. graphic design is her passion 🎨

🎀 Parameters:

• driver=name — name of the database driver. if you don't give one, the default driver gets used. no cap
• database=name — name of the database. if you don't give one, the default database gets used. periodt
• table=name — required. name of the table to drop. you literally cannot skip this one, she needs to know who she's dropping

---

💜 DESCRIPTION 💜

db.droptable drops an attribute table. simple. iconic.

but here's the plot twist bestie: if you do not pass the -f force flag, then nothing gets removed. instead, she just prints a preview of the action she would take. it's giving "here's what I would do to you" energy, and honestly? respect. it's a vibe check before the actual delete 🔥

---

🌸 NOTES 🌸

db.droptable is a front-end to db.execute, made so your life is easier. to some extent it also verifies whether the table is connected to a vector map — you know, to avoid accidental table removal 😭 because accidentally deleting a table is a tragedy and we don't do tragedies here 🫶

bestie, the "avoid accidental table removal" thing is a safety net, not a promise. stay awake.

---

✨ EXAMPLES ✨

🍓 Removing an attribute table from default database

# show default database
db.connect -p
# show available tables
db.tables -p
# this will show what would happen
db.droptable table=sometable
# actually drop the table
db.droptable -f table=sometable

see how the first db.droptable is just the preview? that's the no -f life. then -f comes in and actually does the deed 💅

🧚 Removing an attribute table from given database

db.droptable lets you optionally define driver and database options that are different from your default connection settings (db.connect -p). so you can go somewhere else entirely, main character behavior.

# drop the table from SQLite database
db.droptable -f table=sometable driver=sqlite database=/opt/sqlite.db

look at that path. look at that driver. she's versatile 👑

---

🫶 SEE ALSO 🫶

db.dropdb, db.dropcolumn, db.execute, db.login, db.connect, db.tables, db.describe, v.db.droptable,

GRASS SQL interface

---

👑 AUTHORS 👑

• Markus Neteler
• Driver and database options added by Martin Landa, Czech Technical University in Prague, Czech Republic

---

⭐ SOURCE CODE ⭐

Available at: db.droptable source code (history)

Latest change: Wednesday Mar 12 22:27:28 2025 in commit: 0095480779ff07f10b76a859388850c52b9dccbd

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

© 2003-2026 GRASS Development Team, GRASS 8.5.0 Reference Manual

---

and that's the whole page, bestie 💖 this was db.droptable(1grass) from the GRASS User's Manual, running on GRASS 8.5.0, with that last change landing Wednesday Mar 12 22:27:28 2025 — go forth, drop tables responsibly, and always remember the -f 🎀✨