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.
- If the deleted database Table column is involved in any constraints it will automatically be removed from them