Philip,
- Original Message -
From: "Philip Walden" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, February 02, 2004 3:39 AM
Subject: Why does MySQL generate internal foreign key id when constrain name
> I am using MySQL 4.1.1-1.
>
> Whe
I am using MySQL 4.1.1-1.
When I add a "named" foreign key constraint
alter table sb_query_nm_sub_tp
add constraint f1sbquerynmsubtp foreign key (query_nm) references
sb_query_class (query_nm);
And then do a show create table:
| sb_query_nm_sub_tp | CREATE TABLE `sb_query_nm_sub_tp` (
`q
