title: how to drop a primary key in sql server?
body: <p>how to drop a primary key with t-sql(i mean script)
  like alter table tablename modify primary key..!
  how to write a script to drop a primary key?
  thanks in advance!!!!</p>