[GENERAL] 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),
);