/* Drop views */ if exists (select * from sysobjects where name = 'foo') drop view sa.foo Thanks, Ron White <snippage> Can anyone tell me how can I check whether a view exists, and if it exists to drop it. I'm using ASP with SQL Server 7 on a Windows NT Server 4.0. </snippage>