how can I generate non-clustered primary key?


B

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?
 
Ad

Advertisements

B

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.
 
A

Al Edlund

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

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
 
Ad

Advertisements

B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top