×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: Text
Posted by: user2d6c2
Added: Jun 30, 2017 8:29 PM
Views: 4
Tags: no tags
  1. IF EXISTS ( SELECT 1  FROM sysconstraints  WHERE object_name (constid) = 'fk_BenjiCreditApplicationFact_WithdrawlReasonKey' and id  = OBJECT_ID(N'dbo.BenjiCreditApplicationFact') )
  2. ALTER TABLE dbo.BenjiCreditApplicationFact
  3.                         DROP CONSTRAINT fk_BenjiCreditApplicationFact_WithdrawlReasonKey;
  4. GO