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
