[GENERAL] turning of referential integrity

[XWorkers]

Hi All,
    I am wondering is there any way to turning off referential integrity
without using SET CONSTRAINTS and create table with DEFERRABLE for database
restore purpose?

    TIA.

    --Mursalin.