Table & Index Partitioning (Revision #43)

Script Table Partitioning DDL: Within Aqua Data Studio 8.5, right-click on an Table  in the Schema Browser and select Script Object to Window -> CREATE (Full) from the pop-up menu to generate DDL scripts for Table Partitioning Information.

The Script DDL for Table Partition generation supports the following database vendors and versions, and their Partitioning Types:

• Oracle: Range, List, Hash, Key, Subpartitioning and Composite.
• IBM DB2 UDB LUW : Range.
• MySQL : Range, List, Hash, Key, Subpartitioning and Composite.
• MS SQL Server : Range, List, Hash, Key, Subpartitioning and Composite.
• Sybase ASE : Range, List, Hash, Key, Subpartitioning and Composite.

Script CREATE (Full): Below are examples of the Table Partition Syntax generated when using Script CREATE (Full) for DB2 UDB 9.7, MySQL 6.0, Oracle 11g, MS SQL Server 2008 and Sybase ASE 15.0

Script Index Partitioning DDL: Right-click on an Index in the Schema Browser and select Script Object to Window -> CREATE (Full) from the pop-up menu to generate DDL scripts for Index Partitioning Information.

The Script DDL for Index Partition generation supports the following database vendors and versions, and their Partitioning Types:

• Oracle: Range, List, Hash, Key, Subpartitioning and Composite.
• IBM DB2 UDB LUW : Range.
• MySQL : Range, List, Hash, Key, Subpartitioning and Composite.
• MS SQL Server : Range, List, Hash, Key, Subpartitioning and Composite.
• Sybase ASE : Range, List, Hash, Key, Subpartitioning and Composite.

Script CREATE (Full): Below are examples of the Index Partition Syntax generated when using Script CREATE (Full) for DB2 UDB 9.7, MySQL 6.0, Oracle 11g, MS SQL Server 2008 and Sybase ASE 15.0

CREATE Index and ALTER Index Visual Editing with extended Options: When visually editing (ALTER or CREATE) Indexes, the Options tab now contains the full Index information, including Partitioning information.

Visual Editing Index Information