Answer
ALTER TABLE PETS DROP CONSTRAINT FK_OwnerID
GO
DROP TABLE PET_OWNER
DROP TABLE PETS
Work Step by Step
Drop Foreign Key Constraint
Drop both tables
You can help us out by revising, improving and updating this answer.
Update this answerAfter you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.