Delete Database Table Columns

For a selected database Table, you can review the existing columns and delete any individual column, on the 'Columns' tab of the Columns and Constraints screen.

Access Tools | Database Builder | Click on Table > Columns | Right-click on column name | Delete column <name> (Ctrl+D)

In diagram, right-click on required Table | Features & Properties | Attributes > Columns | Right-click on column name | Delete column '<name>' (Ctrl+D). When you select the 'Delete column '<name>'' option, if all validation rules are satisfied the column is immediately deleted.

Notes

  • If the deleted database Table column is involved in any constraints it will automatically be removed from them

Learn more