Delete a column
Deleting a column from a table causes the information in that column to be deleted and removes the
column heading from the table.
Note: You must have authority to use the Add Reply List Entry (ADDRPYLE) and Change Reply List Entry (CHGRPYLE) commands in order to delete a column.
To delete a column:
- In the System i Navigator window, expand the system you want to use.
- Expand Databases.
- Expand the database and schema that you want to work with.
- Click the Tables container, then right-click the
table and select Definition.
- On the Table Definition dialog, select the Columns tab.
- Select the column that you want to delete and click Remove.
- Click OK.