primary key and foreign key

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

primary key and foreign key

От:
Jessica Richard <rjessil@yahoo.com>
Дата:
Just want to be very clear that:

1. adding a primary key will have an implicit index automatically on the column(s).

2. Adding a foreign key will NOT have an index created automatically, it only does the referencing work. If an index is needed on the F-key column, it has to be created, right?

Thanks.


Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.

Re: primary key and foreign key

От:
Richard Broersma Jr <rabroersma@yahoo.com>
Дата:

--- Jessica Richard  wrote:

> Just want to be very clear that:
> 
> 1. adding a primary key will have an implicit index automatically on the column(s).
> 
> 2. Adding a foreign key will NOT have an index created automatically, it only does the
> referencing work. If an index is needed on the F-key column, it has to be created, right?

Correct.

Regards,
Richard Broersma Jr.

FAQ