Foreign key based on View ?

Data Warehousing Community Forum > Databases > Oracle > Foreign key based on View ?

Pages: [1] Go Down

Author

Topic: Foreign key based on View ? (Read 1184 times)

unknown

DW Apprentice

Reputation: +8/-0
Offline

Offline

Posts: 44

« on: January 19, 2008, 11:48:59 pm »

A foreign key can be created based on a view ?

If so.., Please explain how it can be done ??


	Logged

Thanks
Unknown

Sipra

Founder

Reputation: +59/-0
Offline

Offline

Posts: 323

Am the King...

« Reply #1 on: July 21, 2010, 10:27:00 pm »

No, foreign keys have to be created against user tables.

But guru's say that it can be done with some constraints..! Lips sealed


	Logged

Sipra
Founder

www.dwforum.net

Druid_Elf

DW Fresher

Reputation: +2/-0
Offline

Offline

Posts: 2

« Reply #2 on: July 22, 2010, 12:08:17 pm »

Hi,
As stated it can not be done on the view itself, but I found an article which might allow you to solve your problem

Quote

It comes down to creating to FK on the base table of the view. Hope it helps.


« Last Edit: July 23, 2010, 12:18:57 am by Sipra »	Logged

Pages: [1] Go Up

Jump to: