Re: dropping a primary key

From: <michel.lalonde_at_sit.ulaval.ca>
Date: 1995/04/13
Message-ID: <michel.lalonde.8.0010B97C_at_sit.ulaval.ca>#1/1


In article <D6zAG3.KDL_at_cs.dal.ca> ae873_at_cfn.cs.dal.ca (Murray Kaiser) writes:
>From: ae873_at_cfn.cs.dal.ca (Murray Kaiser)
>Subject: Re: dropping a primary key
>Date: Thu, 13 Apr 1995 14:48:02 GMT
 

>Nagaraj Rekha (nr1_at_Ra.MsState.Edu) wrote:
 

>: Hi netters!!
 

>: I have been trying to drop aprimary key and a foriegn key from a table with
>: out success. I have been using the Disable command.
>: I would appreciate it if any one could tell me where I am going wrong and
>: thr right procedure to do it.

>: Rekha Nagaraj
>: E-mail: rekha_at_erc.msstate.edu

Here's my guess to drop a primary key:

ALTER TABLE table name DROP PRIMARY KEY CASCADE;

Michel Lalonde ;-) Received on Thu Apr 13 1995 - 00:00:00 CEST

Original text of this message