[prev in list] [next in list] [prev in thread] [next in thread] 

List:       solid
Subject:    Re: dropping and creating primary key
From:       Brian Slesinsky <bslesins () best ! com>
Date:       1999-01-21 18:23:46
[Download RAW message or body]


I don't think there's any way to do it with Solid, other than dropping and
creating the table.

----------------------------------------------------------------------
Brian Slesinsky


On Thu, 21 Jan 1999, Yossi Nixon wrote:

> how can I drop  primary key and create a new one over an existing table
> 
> in Oracel I use the following syntax:
> 
> alter table subscriber_history drop primary key;
> alter table subscriber_history add  primary key (id);
> 
> Thanks,
> Yossi
> 
> -----------
> Yossi Nixon
> koor communication & security systems LTD
> Tel: +972-8-913-4949
> Fax:+972-8-913-4860
> Email: koortlm@netvision.net.il
> 

[prev in list] [next in list] [prev in thread] [next in thread]