Can someone please help me to understand below trigger statemet- ALTER TABLE [Product].[Category] WITH CHECK ADD CONSTRAINT [FK_Product_CategoryID] FOREIGN KEY([CategoryID]) REFERENCES [Product].[CategoryList] ([CategoryID]) GO ALTER TABLE [Product].[Category] CHECK CONSTRAINT [FK_Product_CategoryID] GO When i alter the trigger to see the definition i found it has again alter table same trigger as check constraint(2nd alter statement). Is this correct. Can it cause some issues like slow/hang? my whole db is hanging and i am trying to troubleshoot the issue. Please help.