db.dropcolumn(1grass)

💅 db.dropcolumn — the GRASS manual, but make it make sense

okay bestie, welcome to db.dropcolumn(1grass), straight out of the GRASS User's Manual, and lemme tell u this little icon does ONE thing and does it cute: it drops a column from selected attribute table. that's it. that's the gig. 🎀

---

✨ NAME ✨

db.dropcolumn — drops a column from selected attribute table. no notes. periodt. 💖

---

🔑 KEYWORDS 🔑

database, attribute table

---

🦋 SYNOPSIS 🦋

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

---

🌸 Flags 🌸

• -f — Force removal (required for actual deletion of files). yes girl, nothing gets deleted unless u say -f. it's giving safety rails. 🛡️
• --help — Print usage summary
• --verbose — Verbose module output
• --quiet — Quiet module output
• --ui — Force launching GUI dialog

---

🎀 Parameters 🎀

• table=name [required] — Name of attribute table
• column=name [required] — Name of attribute column
• database=name — Name of database
• driver=name — Name of database driver
  • Options: dbf, odbc, ogr, sqlite, pg

---

💜 DESCRIPTION 💜

so db.dropcolumn drops a column from an attribute table. that's the whole personality.

BUT. here's the plot twist 👀 — if the -f force flag is not given, then literally nothing is removed. instead it prints a preview of the action that would be taken. it's a vibe check before the commitment, fr fr.

no cap: no -f, no deletion. only the little preview of your future. 🔮

---

🧚 NOTES 🧚

db.dropcolumn is a front-end to db.execute — it exists so u can do this without suffering ✨ — and it comes with a special workaround for the SQLite driver so that column drop is supported for SQLite tables too. slay. 💅

---

🍓 EXAMPLE 🍓

Dropping a column (North Carolina sample dataset):

# 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

see how the first one just describes the drama and the second one with -f actually goes through with it? main character energy only. 👑

---

🌈 SEE ALSO 🌈

db.describe, db.droptable, db.execute, v.db.dropcolumn, GRASS SQL interface

---

👑 AUTHOR 👑

Markus Neteler

---

⭐ SOURCE CODE ⭐

Available at: db.dropcolumn 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

---

okay that's the whole page, bestie, we ate and left zero crumbs 🫶

and for the cute sign-off: this whole thing is © 2003-2026 GRASS Development Team, from the GRASS 8.5.0 Reference Manual, footer stamped GRASS 8.5.0 on one end and db.dropcolumn(1grass) on the other. obsessed with her. 🌸✨💖