SQL Query check if unique constraint is Updated , If its not Altered then run Alter Query

Question

SQL Query check if unique constraint is Updated , If its not Altered then run Alter Query

Indudhar Gowda 426

I need a IF Statement to check and run SQL Query

  alter table [ReportableResults] add constraint   
   Unique_ReportableResults_ReportableResultCode_IsCalculated unique (ReportableResultCode, IsCalculated);

Above Code is Working Fine.....But I dont want to run Everytime...

I want to check if its already altered then not need to run the Above Query.

Indudhar Gowda 426 Reputation points

2022-06-03T03:49:36.657+00:00

I just need a if statement

Answer accepted by question author

0 additional answers

Your answer

Indudhar Gowda 426 Reputation points

2022-06-03T03:49:36.657+00:00

I just need a if statement

Answer 1

Tom Cooper 8,501

The following code will create the constraint if there is no object named Unique_ReportableResults_ReportableResultCode_IsCalculated, but if it already exists, the code will do nothing.

If Not Exists(Select * From sys.objects Where Name = 'Unique_ReportableResults_ReportableResultCode_IsCalculated')
  alter table [ReportableResults] add constraint
   Unique_ReportableResults_ReportableResultCode_IsCalculated unique (ReportableResultCode, IsCalculated);

Tom

0 comments

Share via

SQL Query check if unique constraint is Updated , If its not Altered then run Alter Query

0 additional answers

Your answer