cleanup.sql

< SQL Server2005程序设计>

DROP PROCEDURE spContacts
DROP PROCEDURE spContactCount

DROP TRIGGER Person.trgUpdateContact
DROP TRIGGER trgCreateTable on database
UPDATE Person.Contact SET FirstName = 'Gustavo' WHERE ContactId = 1

DROP FUNCTION fnHelloWorld
DROP FUNCTION fnToCelsius
DROP FUNCTION fnPortfolioTable

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

DROP TYPE typBakersDozen

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

DROP ASSEMBLY Chapter03