Set INDEX type for PRI KEY in Primary Key Dialogue Box.
There doesn't appear to be anyway to define the Index type used on a Primary Key column when creating a table or altering a table without hand writing the DDL SQL. Please consider adding a drop down box in the Primary Key Properties dialogue box so this can be set when choosing other Primary key properties. Thanks.
1
vote
Timbald
shared this idea
This can be achieved as follows:
1. Expand a table in Database Explorer.
2. Right-click the ‘Indexes’ node.
3. Select ‘New Index…’ from the popup menu.
-
Timbald
commented
But this doesn't solve the question - why not also add this function to the Pri Key area in the New column properties box at the point of table creation? Bit of an annoyance to leave defining the Pri Key when building a table and then have to do it in Indexes later on?
Many thanks.