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.

Notes

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

 

Learn more