Add one or more columns to a table or global temporary table, add or change attributes and options, including partitioning, constraints, and compression. You can also drop columns, change a join index, or revalidate a table.
- Rules and Restrictions for ALTER TABLE (Basic Table Parameters)
- Referential Integrity Error Tables for Column-Partitioned Tables
- ALTER TABLE Support for UDTs
- Recommended Null Handling Technique for UDT Columns
- Working with Columns and Statistics
- ALTER TABLE and FALLBACK
- Types of Journaling Supported by ALTER TABLE (Basic Table Parameters)
- FREESPACE PERCENT with ALTER TABLE (Basic Table Parameters)
- MERGEBLOCKRATIO with ALTER TABLE (Basic Table Parameters)
- BLOCKCOMPRESSION (ALTER TABLE)
- Adding Columns to a Table
- Adding Columns to a Column-Partitioned Table
- Adding Columns to a Column Partition in a Column-Partitioned Table
- Adding Columns to a Normalized Table
- Working with Column and Data Type Attributes
- Modifying Column Data Types or Multivalue Compression
- Using Compression Methods with Table Columns
- Adding and Dropping CHECK Constraints
- Dropping Columns from a Table
- Renaming Table Columns
- Adding or Dropping PRIMARY KEY and UNIQUE Constraints
- Rules for Adding or Dropping Constraints
- Maintaining Foreign Key Integrity
- Referential Integrity When a Table Is Inconsistent
- Rules for Changing Column Data Types
- Procedure to Change Column Data Types