Re: primary key over two columns

2001-01-17 Thread Jan Dvorak
Hi, Asaf Maruf wrote: > > How can i specify two columns together as primary key for a table. > > Using create table test > (increment int , id int not null primary key, date not null primary key, name >char(20) ); > > doesn't work. You should rather say create table test ( increment int ,

Re: primary key over two columns

2001-01-16 Thread Steve Ruby
Asaf Maruf wrote: > > Dear all on list > > How can i specify two columns together as primary key for a table. > > Using create table test > (increment int , id int not null primary key, date not null primary key, name >char(20) ); > > doesn't work. > > Is it possible that one column is tex

primary key over two columns

2001-01-16 Thread Asaf Maruf
Dear all on list How can i specify two columns together as primary key for a table. Using create table test (increment int , id int not null primary key, date not null primary key, name char(20) ); doesn't work. Is it possible that one column is text and other is integer? Help would be ap