USE [eFiscali_3] GO if exists (select name from sysobjects where name='XPKCustomerSupplier' and type='K') begin ALTER TABLE CustomerSupplier drop CONSTRAINT XPKCustomerSupplier ALTER TABLE CustomerSupplier ADD CONSTRAINT XPKCustomerSupplier PRIMARY KEY CLUSTERED ( CompanyCode ASC, VATYear ASC, SourceApplType ASC, CustSupplType ASC, CustSupplCode ASC ) end GO