Prev Next

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

Use one of the methods outlined here to display a list of columns for a table, then select a column and delete it.

When you select the 'Delete column '<name>'' option, if all validation rules are satisfied the column is immediately deleted.

Ribbon

Specialize > Tools > Database Builder > Click on Table > Columns > Right-click on column name > Delete column <name>

Context Menu

In diagram, right-click on required Table | Features & Properties | Columns | Right-click on column name | Delete column <name>

Keyboard Shortcuts

F9 | Use 'Up Arrow' or 'Down Arrow' to select a column | Ctrl+D

Notes

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

Learn more