Mehmet,
I am sorry if I am asking you a basic question.

I feel I am doing it the same way as you mentioned in the topic.
The following is the query:

SET INTEGRITY FOR TEST.EMP OFF!
SET INTEGRITY FOR TEST.EMP FOREIGN KEY IMMEDIATE UNCHECKED!
DELETE FROM TEST.EMP WHERE EMPID=1!
SET INTEGRITY FOR TEST.EMP IMMEDIATE CHECKED!

Here, The EMP table has been referrenced in few other child tables.

Please suggest if there is any thing wrong in the above statements.
If anybody else could give me a suggestion, it would be of great help.

Thanks in advance,
Santhosh