CONSTRAINT [pk_SwitchboardItems]

[Frank Situmorang]

Helllo:

In the table structure of the following, can anyone explain what is the
meaning of :
CONSTRAINT [pk_SwitchboardItems]?

CREATE TABLE [Switchboard Items] (
[SwitchboardID] LONG NOT NULL,
[ItemNumber] SMALLINT NOT NULL,
[Language] TEXT(50) NOT NULL,
[ItemText] TEXT(255) NOT NULL,
[Command] SMALLINT,
[Argument] TEXT(255) ,
CONSTRAINT [pk_SwitchboardItems]
PRIMARY KEY ([SwitchboardID], [ItemNumber], [Language])
);


Thanks very much

 

[RoyVidar]

Helllo:

In the table structure of the following, can anyone explain what is
the meaning of :
CONSTRAINT [pk_SwitchboardItems]?

CREATE TABLE [Switchboard Items] (
[SwitchboardID] LONG NOT NULL,
[ItemNumber] SMALLINT NOT NULL,
[Language] TEXT(50) NOT NULL,
[ItemText] TEXT(255) NOT NULL,
[Command] SMALLINT,
[Argument] TEXT(255) ,
CONSTRAINT [pk_SwitchboardItems]
PRIMARY KEY ([SwitchboardID], [ItemNumber], [Language])
);


Thanks very much

The last two lines,

CONSTRAINT [pk_SwitchboardItems]
PRIMARY KEY ([SwitchboardID], [ItemNumber], [Language])

creates a primary key index called pk_SwitchboardItems consisting
of the fields SwitchboardID, ItemNumber and Language

For more info, see for instance
http://office.microsoft.com/en-us/access/HP010322141033.aspx