Re: how to set more than two attributes as primary keys in a table

On Sun, Dec 28, 2003 at 20:21:32 -0800,
Peggy Go <shatz_go(at)yahoo(dot)com> wrote:
> Hi!...
>
> Normally, there is only one attribute for the primary
> key but in my table, my primary key is composed of two
> attributes. How do I state this in SQL? What if
> Region_num and Num_Players, combined, should form a
> primary key?
>
CREATE TABLE REGION (
Region_Num smallint,
Num_Players smallint,
Player_Num smallint,
primary key (Region_Num, Num_Players)
);