/*
Script to delete the auto repair tables.
*/

/* Drop the REPAIR table and constraints */

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[fk_custID]') AND parent_object_id = OBJECT_ID(N'[dbo].[repairorder]'))
ALTER TABLE [dbo].[repairorder] DROP CONSTRAINT [fk_custID]
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[fk_vin]') AND parent_object_id = OBJECT_ID(N'[dbo].[repairorder]'))
ALTER TABLE [dbo].[repairorder] DROP CONSTRAINT [fk_vin]
GO


IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[repairorder]') AND type in (N'U'))
DROP TABLE [dbo].[repairorder]
GO



/* Drop the VEHICLE table and constraints */


IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[fk_ownerID]') AND parent_object_id = OBJECT_ID(N'[dbo].[vehicle]'))
ALTER TABLE [dbo].[vehicle] DROP CONSTRAINT [fk_ownerID]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[vehicle]') AND type in (N'U'))
DROP TABLE [dbo].[vehicle]
GO


/* Drop the CUSTOMER table and constraints */

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[customer]') AND type in (N'U'))
DROP TABLE [dbo].[customer]
GO