SEO

#1 (**permalink**) 04-03-2008, 02:50 PM

hi all i have a question for you all ^^...

it's possible to create a foreign keys that is related not on a table , but
on a view?

if possible, the view must be a merge view or also a temptbale?

thx to all

Livio

#2 (**permalink**) 04-03-2008, 02:50 PM

slepland@italianvampires.it wrote:
> hi all i have a question for you all ^^...
>
>
> it's possible to create a foreign keys that is related not on a table , but
> on a view?
>

No. A view does not contain any data. It is only a different way of
representing data which already exists in other table(s).

> if possible, the view must be a merge view or also a temptbale?
>

I'm not sure what you're talking about here.

> thx to all
>
> Livio
>
>
>

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
=================

#3 (**permalink**) 04-03-2008, 02:50 PM

> it's possible to create a foreign keys that is related not on a table , but
> on a view?
>
> if possible, the view must be a merge view or also a temptbale?

No. A foreign key is a constraint. You can only have constraints on
tables, not on views.

If you want to have identities that are unique across several tables,
consider using an "identity table" with nothing more than an
autoincrement field. Is that what you mean?

Best regards,
--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

foreign keys on view