predeployscript.sql

< SQL Server2005程序设计>

IF EXISTS (SELECT * FROM sys.tables WHERE object_id = OBJECT_ID(N'[dbo].[tblPoint]'))
DROP TABLE dbo.tblPoint
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[Person].[trgUpdateContact]'))
DROP TRIGGER Person.trgUpdateContact