Book a Demo

Author Topic: non clustered PK's  (Read 1931 times)

tprohas

  • EA User
  • **
  • Posts: 32
  • Karma: +0/-0
    • View Profile
non clustered PK's
« on: April 12, 2004, 11:01:55 am »
Does anyone know how to create a nonclustered PK with SQL Server 2000? I have not been able to do this and its causing me problems when generating DDL. The DDL won't execute because I end up with the PK being clustered and a second column on the table being clustered.

thanks,

Aaron