/* Advanced SQL
DIVISION problem - Drop workshop and attendance tables.
*/


USE [ES10000]
GO


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

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

USE [ES10000]
GO

/****** Object:  Table [dbo].[attendances]    Script Date: 06/15/2011 15:41:51 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[attendances]') AND type in (N'U'))
DROP TABLE [dbo].[attendances]
GO


/****** Object:  Table [dbo].[workshops]    Script Date: 06/15/2011 15:58:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[workshops]') AND type in (N'U'))
DROP TABLE [dbo].[workshops]
GO