Book a Demo

Author Topic: Create nonclustered PK in DDL  (Read 2198 times)

tprohas

  • EA User
  • **
  • Posts: 32
  • Karma: +0/-0
    • View Profile
Create nonclustered PK in DDL
« on: April 21, 2004, 11:15:14 am »
I asked this question a while back and didn't get a single response so I am trying again. Does anyone know how to generate DDL for SQL Server 2000 that will create the primary key field as nonclustered? It seems that the DDL that EA creates always makes the PK clustered, but I don't want this as I want to make a different column in the table the clustered column.

thanks,

Aaron