Thread: Foreign key referencing a VIEW

Foreign key referencing a VIEW

From
Laurent Martelli
Date:
Hi all,

I have a feature request for our dear fellow developpers : I would like to be able to create a foreign key constraint that references a view (or anything that looks like a table, as a function returning a table for instance) instead of a table.

Does that look doable ? The trickiest part is probably to ensure the constraint when the tables the view is built on are modified...

Cheers,
Laurent