下面这段语句是修改视图：

USE pubs

GO

ALTER VIEW yourview

AS

SELECT title, mycount= @@ ROWCOUNT, ytd_sales

    FROM titles

    WHERE type = 'mod_cook'

GO

SELECT *

FROM yourview

GO
下面这段语句是删除触发器employee_insupd：

USE pubs

IF EXISTS (SELECT name FROM sysobjects

  WHERE name = 'employee_insupd' AND type = 'TR')

   DROP TRIGGER employee_insupd

GO