---
name: "db.dropcolumn"
section: "1grass"
platform: "linux"
package: "grass-doc"
version: "8.4.1-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/db.dropcolumn"
---

# db.dropcolumn(1grass)

Drops a column from selected attribute table.

## NAME

**db.dropcolumn**  - Drops a column from selected attribute table.

## 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)

- **--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

*db.dropcolumn* drops a column from an attribute table. If the **-f** force flag is not given then nothing is removed, instead a preview of the action to be taken is printed.

## NOTES

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

## 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 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)

Accessed: Monday Feb 24 17:51:43 2025

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

© 2003-2025 GRASS Development Team, GRASS GIS 8.4.1 Reference Manual