Re: [SQL] Cluster and primary key

2001-06-12 Thread Mathijs Brands
On Tue, Jun 05, 2001 at 07:51:11AM +, Mikael Kjellström allegedly wrote: > I can't find a way to cluster a table on another index and keep it's > primary key. > > When I define the table the primary key is created, but it's dropped when I > cluster the table on another index. > > I've trie

[SQL] Cluster and primary key

2001-06-12 Thread Mikael Kjellström
I can't find a way to cluster a table on another index and keep it's primary key. When I define the table the primary key is created, but it's dropped when I cluster the table on another index. I've tried "alter table add constraint", but that's not supported for primary keys. I'm running 7.