Table & Index Partitioning (Revision #77)

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, Reference, Composite Range, Comosite List & System.
• IBM DB2 UDB LUW : Range.
• MySQL : Hash, Key, Linear Hash, Linear Key, Range & List.
• MS SQL Server : Partition Functions, Partition Schem, ON Partition_Scheme_Name.
• Sybase ASE : Range, List, Hash & Roundrobin.

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

Oracle	IBM DB2 UDB	MySQL	MS SQL	Sybase ASE

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
• MS SQL Server 
• Sybase ASE

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

Oracle	MS SQL	Sybase ASE

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

• DB2 UDB
• Oracle
• MS SQL Server 
• MySQL
• Sybase ASE

DB2 UDB Full Index Information	Oracle Full Index Information	MS SQL Full Index Information	MySQL Full Index Information	Sybase Full Index Information

MySQL Index Column Charsize allows indexes to be CREATEd on the leading part of column values, using col_name(length) syntax to specify an index prefix length. Prefixes can be specified for CHAR, VARCHAR, BINARY, and VARBINARY columns.

Index Column Size