Alter Table -- Overview

Use the Alter Table notebook to alter a table.

Tasks

• Changing table properties
• Adding columns
• Changing column comments
• Changing the length of an existing VARCHAR column
• Defining the primary key
• Changing the primary key
• Adding partitioning key columns
• Removing partitioning key columns
• Adding foreign keys
• Changing foreign keys
• Adding check constraints
• Changing check constraints

Page controls

• Table
• Columns
• Primary Key
• Partitioning Key
• Foreign Keys
• Check Constraints

Controls

• OK
• Cancel

Related information

• Renaming a table
• Adding table privileges

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

[ DB2 List of Books | Search the DB2 Books ]