title: Can we drop and recreate primary key in SQL Server table @ Production environment? Do we have to down the server for it or we can do it live?
body: <p>Can we drop and recreate a composite primary key in a SQL Server table in production environment? Do we have take down the server for it, or can we do it live?</p>
  
  <p>Because we have to add more columns to the primary key. If we done it in live what are the problems we have to face?</p>