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 In diagram, right-click on required Table | Features & Properties | Attributes > Columns | Right-click on column item | 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|