how can I generate non-clustered primary key?

[Bala]

I need a clustered index (not PK), but the PK is clustered by default.

I need Visio to generate:
add constraint "my_table_PK" primary key nonclustered ("my_pk_column")

Anyone?

 

[Bala]

I need a clustered index (not PK), but the PK is clustered by default.

I need Visio to generate:
add constraint "my_table_PK" primary key nonclustered ("my_pk_column")

Anyone?

The lack of response tell me this cannot by done.

 

[Al Edlund]

or the people that monitor this forum are unaware of a solution.
al

 

[Glen]

Hi,

Did you ever get this solved?

I also have a similar problem.

I have a clustered key on a table, and also need a primary key - but they
are on different columns.

Visio is complaining: 2 clustered indexes defined. Only one clustered
index allowed per table.

So, I need to tell Visio that the primary key will not be clustered.

Glen

 

[Barb Way]

Just checking in with you to see if this was still an open question.

We do not have a selection item which would allow you to specify individual
characterstics for the Primary Key, but in my own testing I don't see this
happening. What version of Visio are you using, and what database driver
is being used in your model? (I was testing with SQL Server and using
Visio for Enterprise Architects from Visual Studio 2005.)


Barb Way
Product Support - Visio
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.