Hi,
In the current app I'm writing, it would be very useful if I could
store the information that a column references another table (my SQL
generation is automated), eg
CREATE TABLE foo (
...
tel1 INT UNSIGNED NOT NULL,
tel2 INT UNSIGNED NOT NULL,
foreign key (tel1) references telefone,
foreign key (tel2) references telefone
)
and later retrieve this info via Perl DBI. Failing that, I will have
to store just the foreign key definitions elsewhere (which is a bit
annoying).
>From the manual, I'm afraid it isn't possible. Is it really so?
Thanks,
--
Adriano
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Foreign keys just for table metadata?
Adriano Nagelschmidt Rodrigues Thu, 24 May 2001 13:26:12 -0700
- Re: Foreign keys just for table metadata? Adriano Nagelschmidt Rodrigues
- Re: Foreign keys just for table metada... Rolf Hopkins
- Re: Foreign keys just for table me... Adriano Nagelschmidt Rodrigues
