If Exists（Select * From OtherTable 
其中OtherTableFKColumn = MainTablePrimaryKey）
 Begin 
回滚事务
 RaisError（'表中的违反FK约束[OtherTable]'，16，1 ）
 End 
 

I have following situation. A main table and many other tables linked together with foreign keys. Now when I would like to delete a row in the main table a ConstraintsViolation will occur, which is intended and good.

Now I want to be able to check if the ConstraintsViolation will occur before I trigger the delete row event.

Is this possible?

If Exists ( Select * From OtherTable
            Where OtherTableFKColumn = MainTablePrimaryKey) 
   Begin
       Rollback Transaction
       RaisError('Violating FK Constraint in Table [OtherTable]', 16, 1)
   End