Home > SQL Developer: TimesTen Tasks > Change the Attributes of Pr...
You can change the attributes of a primary key constraint after you have defined a primary key on a table. Follow these steps:
Click the + to the left of the Tables node to view the list of tables. Then right-click the name of the table on which to change the primary key attributes.
Select Constraint, then select Change Primary Key Parameters.
The Change parameters of a primary key dialog appears.
In the key index type field choose either Use range to change the primary key constraint from using a hash index to using a range index or Use hash to change the primary key constraint from using a range index to using a hash index.
If you choose Use hash, you see the text with number of followed by a drop-down list of either row or pages. Select either row or pages and in the box after the colon (:), enter the number of rows or pages. The default selection is row.
For more information on hash index sizing, see "Column Definition" in Oracle TimesTen In-Memory Database SQL Reference.
Click Apply.
The Confirm dialog appears indicating that the index(es) for the primary key constraint has been changed.
Click OK.
The index(es) for the primary key constraint has been changed successfully.
To view the SQL statement used to change the attributes of the primary key constraint, choose the SQL tab of the Change parameters of a primary key dialog.
For information about changing the attributes of a primary key constraint, see "ALTER TABLE" in the Oracle TimesTen In-Memory Database SQL Reference.
Related Topics