R>LIST CONSTRAINTS FOR <tablename> You will get a list of constraints named #999 R>ALTER TABLE <tablename> DROP CONSTRAINT #999
"Fogelson, Steve" <[EMAIL PROTECTED]> wrote: >Thanks Ben > >Got a sample from the UNLOAD command. > >DROP INDEX doesn't seem to want to drop Foreign Keys (ERROR - Index not >found). > >Do I use ALTER TABLE for that too? > >I tried > >ALTER TABLE Categories DROP CONSTRAINT FOREIGN KEY CP_ID >ALTER TABLE Categories DROP CONSTRAINT CP_ID > >Neither worked. How do I get the conname > >Steve > >-----Original Message----- >From: Ben Johansen [mailto:[EMAIL PROTECTED] >Sent: Thursday, October 02, 2003 3:14 PM >To: [EMAIL PROTECTED] >Subject: [RBASE-L] - RE: Create Index > > >You would need to use the ALTER TABLE command to create a foreign key > >Ben Johansen - http://www.pcforge.com >Authorized Witango & MDaemon Reseller >Available for Witango Developement > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of >Fogelson, Steve >Sent: Thursday, October 02, 2003 1:08 PM >To: RBASE-L Mailing List >Subject: [RBASE-L] - Create Index > >Using R:Base 6.5+ > >Can you use CREATE INDEX to create a foreign key. If so, can you provide >an >example. > >Thanks > >Steve Fogelson >Internet Commerce Solutions > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
