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:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Click the Tables container, then right-click the table and select Definition.
  5. On the Table Definition dialog, select the Columns tab.
  6. Select the column that you want to delete and click Remove.
  7. Click OK.