T-SQL Template to Create or Alter a View without loosing already configured metadata like authorization.

Create or Alter View.sql

-- =============================================
-- Create or Alter View template
-- =============================================
USE <database_name, sysname, AdventureWorks>
GO

IF OBJECT_ID(N'[<schema_name, sysname, dbo>].[<view_name, sysname, Top10Sales>]', 'V') IS NULL
	EXEC sp_executesql N'CREATE VIEW [<schema_name, sysname, dbo>].[<view_name, sysname, Top10Sales>] AS SELECT '''' as [x]'
GO

ALTER VIEW [<schema_name, sysname, dbo>].[<view_name, sysname, Top10Sales>] AS
<select_statement, , SELECT TOP 10 * FROM Sales.SalesOrderHeader ORDER BY TotalDue DESC>