|
-
Hello,
Can any body answer these questions in the order they appear please?
1.Can you insert into a table that has foreign key constraint without doing anything to the primary key? I have a table that has foreign key columns, can any one tell me if I can insert into those columns without doing anything to the primary keys that are on another table?
2. How doy find out what table is the foreign key referencing from. I have a table that has foreign key columns but I'm trying to find out where the primary keys that the foreign keys are referencing is located? I tried using DBA_CONSTRAINS, and DBA_CONS_COLUMNNS but it did not help.
regards,
dorothy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|