On Saturday, April 09, 2011 2:59:06 pm Carlos Mennens wrote:
>
>
> Is there a difference between an INDEX and a CONSTRAINT?
Oops forgot to add this to my previous reply.
The short version, an INDEX is one form of a CONSTRAINT. For the long version
look at the CREATE TABLE section of the docs. It shows the various CONSTRAINTS
available for both columns and tables i.e NOT NULL, FOREIGN KEY, etc
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com