|alter table docket drop foreign key clno
|gives error message
========================================
Bernie,
You need the name of the constraint. To get it, use:
LIST CONSTRAINTS
Then:
ALTER TABLE docket DROP CONSTRAINT constraintname
---------------------------------------------------------------------------
Eric M. Bienstock, Ph.D.
Database Development, etc.
Authorized R:BASE Developer
Eric M. Bienstock & Associates, Inc.
day: 212-978-7948 eve: 973-763-8650(8)
FAX: 775-254-2109 [EMAIL PROTECTED]
http://mywebpages.comcast.net/ericmb/
---------------------------------------------------------------------------
----- Original Message -----
From: Bernard Lis
To: [EMAIL PROTECTED]
Sent: Saturday, March 16, 2002 3:18 PM
Subject: need more syntax help on alter
alter table docket drop foreign key clno
gives error message: table constraints may only be added or dropped
Bernie Lis
Megabytes, Inc.
================================================
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/
