Обсуждение: What is the difference of foreign key?

Поиск
Список
Период
Сортировка

What is the difference of foreign key?

От
sheepjxx
Дата:
To be precise,
 
The difference between

create table a (
     foreign key (id) referenced by b(name),
);

create table b(
      id  integer referenced by b(name),
);

Re: What is the difference of foreign key?

От
Lew
Дата:
sheepjxx wrote:
> To be precise,
>
> The difference between
>
> create table a (
>      foreign key (id) referenced by b(name),
> );
>
> create table b(
>       id  integer referenced by b(name),
> );

They're just two different forms of invalid SQL.  The difference between them
makes no difference.

--
Lew