Hi Michael,

> And what if I have a foreign key ?
>
> Does this also automatically makes an index ?

A foreign key automatically creates an index on your
child table - that is, the columns that have to have
values from the master table.

btw - this is all covered in the InterBase documentation :-)


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com