... But it does, at least as far as the dropping of tags is concerned. My question is are there limitations or gotchas? This code run fine:
CREATE TABLE tagtest free; (name c(20), date d, amount n(10,2)) INSERT INTO tagtest VALUES ("bob", DATE(), 75) INSERT INTO tagtest VALUES ("rob", DATE()-20, 43) INSERT INTO tagtest VALUES ("sam", DATE()+7, 95) INSERT INTO tagtest VALUES ("rachael", DATE()-300, -7) INDEX on name TAG names INDEX on date TAG dates ALTER table tagtest; drop foreign KEY TAG names -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Leafe Sent: Friday, July 21, 2006 7:55 AM To: [EMAIL PROTECTED] Subject: Re: drop foreign key tag ... On Jul 21, 2006, at 7:47 AM, Lew wrote: > I'm looking for the sql equivalent to drop tag ... for contained > and/or free tables. alter table ... drop foreign key tag ... seems to > work VFP SQL doesn't support the creation/deletion of ordinary tags. Just use INDEX ON and DELETE TAG as usual. -- Ed Leafe -- http://leafe.com -- http://dabodev.com [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.