CHILD_RECORD_FOUND Equivalent in SQL Server

HI All..,,

for CHILD_RECORD_FOUND in Oracle , in SQL Server is Error_number = 547


begin try
---------
----------
end try
 begin catch 

     if @errornumber = 547
     print 'Unable to delete Parent , as child record exists'
 end catch



for 547 ===> delete statement conflicted with the reference constraint