Re: Creation of FK without enforcing constraint for existing data

2022-08-02 Thread Gavan Schneider
On 2 Aug 2022, at 17:14, sivapostg...@yahoo.com wrote: Hello, I need to create a Foreign Key for a table without enforcing the constraint for existing data.   Few orphan exists in existing data, which we plan to resolve it later.   We use the following query to create the FK [ Which of course

Re: Creation of FK without enforcing constraint for existing data

2022-08-02 Thread sivapostg...@yahoo.com
Hello, I need to create a Foreign Key for a table without enforcing the constraint for existing data.   Few orphan exists in existing data, which we plan to resolve it later.   We use the following query to create the FK [ Which of course checks for the presence of record in referencing table]