Frank Situmorang wrote:
[Quoted Text] > 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
--
Roy-Vidar
|