<p>In Oracle, I can re-create a view with a single statement, as shown here:</p>

<pre><code>CREATE OR REPLACE VIEW MY_VIEW AS
SELECT SOME_FIELD
FROM SOME_TABLE
WHERE SOME_CONDITIONS
</code></pre>

<p>As the syntax implies, this will drop the old view and re-create it with whatever definition I've given.</p>

<p>Is there an equivalent in MSSQL (SQL Server 2005 or later) that will do the same thing?</p>

You can use 'IF EXISTS' to check if the view exists and drop if it does.
```
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
        WHERE TABLE_NAME = 'MyView')
    DROP VIEW MyView
GO

CREATE VIEW MyView
AS 
     ....
GO
```