how to delete the tables created

[landon kelsey]

drop table pets_like_boys;
drop table boys_like_girls;
drop table girls_like_pets;

create table pets_like_boys (pets_name varchar(32), boys_name varchar(32),primary key (pets_name)) type=innodb;
create table boys_like_girls (boys_name varchar(32), girls_name varchar(32),primary key (boys_name)) type=innodb;
create table girls_like_pets (girls_name varchar(32), pets_name varchar(32),primary key (girls_name)) type=innodb;

insert into pets_like_boys values('fluffy', 'sam');
insert into pets_like_boys values('rover', 'bob');
insert into pets_like_boys values('skippy', 'joe');

insert into boys_like_girls values('bob','jill');
insert into boys_like_girls values('sam','betty');
insert into boys_like_girls values('joe','sue');
insert into boys_like_girls values('george','jill');

insert into girls_like_pets values('sue','fluffy');
insert into girls_like_pets values('jill','skippy');
insert into girls_like_pets values('betty','rover');

alter table pets_like_boys add constraint pets_like foreign key (boys_name) references boys_like_girls(boys_name) on delete cascade;
alter table boys_like_girls add constraint boys_like foreign key (girls_name) references girls_like_pets(girls_name) on delete cascade;
alter table girls_like_pets add constraint girls_like foreign key (pets_name) references pets_like_boys(pets_name) on delete cascade;

select * from pets_like_boys;
select * from boys_like_girls;
select * from girls_like_pets;
delete from boys_like_girls where boys_name = 'bob';
select * from pets_like_boys;
select * from boys_like_girls;
select * from girls_like_pets;


all 4 failed:

ALTER TABLE boys_like_girls DROP KEY `boys_name`;

ALTER TABLE boys_like_girls DROP KEY `girls_name`;


ALTER TABLE boys_like_girls DROP constraint `boys_like`;

ALTER TABLE boys_like_girls DROP constraint `girls_like`;


ALTER TABLE boys_like_girls DROP foreign KEY `boys_name`;

ALTER TABLE boys_like_girls DROP foreign KEY `girls_name`;



Edited 2 time(s). Last edit at 09/02/2008 06:14PM by landon kelsey.