Removing partitioning key columns when altering a table

Use the Partitioning Key page of the Alter Table notebook to add or remove partitioning key columns.

The partitioning key can only be altered if this table resides in a single-node nodegroup.

Before you begin...

To remove partitioning key columns:

1. Open the Alter Table notebook.

2. Click on the Partitioning Key tab.

3. In the Partitioning key columns box, select the columns that you want to remove.

4. Click on the < push button to move the selected columns to the Available columns box.

5. If you do not want to make any additional changes to the table, click on OK to alter your table and close the Alter Table notebook. Otherwise, continue on to one or more of the optional tasks.

Related information

• Partitioning key -- See the SQL Reference

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]