| 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 |
Develop > Data Modeling > Database Builder > Click on Table > Columns > Right-click on column name > Delete column <name> |
|
Context Menu |
In diagram, right-click on required Table | Features | Columns | Right-click on column name | Delete column <name> |
|
Keyboard Shortcuts |
| Use '' or 'Down Arrow' to select a column | |
Notes
- If the deleted database Table column is involved in any constraints it will automatically be removed from them