-- John Wilkinson (MS50)
-- Databases (COMS 30103) - Dr. J.Gallagher
-- Video Shop - Assignment 2
------------------------------------------------------------------------
-- drop_video_schema.sql - used to remove schema during development
------------------------------------------------------------------------


alter table Rental drop constraint Rental_Video;
alter table Rental drop constraint Rental_Shop;
alter table Rental drop constraint Rental_Member;
drop table Video;
drop table Shop;
drop table Member;
drop table Rental;
drop table message_s;