Dropping foreign keys

• kensai

  Old Hand

  Points: 352

  More actions

  September 12, 2002 at 11:27 am

  #79458

  How can I drop a foreign key with T-SQL?

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  September 12, 2002 at 11:55 am

  #436409

  ALTER TABLE <Table Name>

  DROP CONSTRAINT <Constraint Name>

  K. Brian Kelley

  http://www.truthsolutions.com/

  Author: Start to Finish Guide to SQL Server Performance Monitoring

  http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

  K. Brian Kelley
  @kbriankelley