On Sat, 16 Mar 2002 15:18:17 -0500, Bernard Lis wrote:

>alter table docket drop foreign key clno

Bernie,

First do the command:

LIST CONSTRAINT FOR DOCKET

The item under the ID column where the column name is clno is the 
name of the constraint you want to drop.  If it were #157, then your 
next command would be:

ALTER TABLE docket DROP CONSTRAINT #157

Bill





================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/

Reply via email to