Operations for SQL Server views

--Determine if the name of the view you want to create exists
if exists (SELECT * from dbo.sysobjects WHERE id = object_id (N ' [dbo].[ View name] ') and OBJECTPROPERTY (ID, N ' isview ') = 1)
--Delete View
Drop view [dbo]. [View name]
GO

--Example:

--Delete View
Drop View Getfinancelogview
--Create a view
Create View Getfinancelogview
With SCHEMABINDING
As
Select Id,outcashaccountno, Incashaccountno,amount,remarkcontent,type,status,addtime,runwater,operationtype from Dbo. Financelog

--building an index
if (exists (SELECT * from sys.indexes where name = ' Idx_prod_productprogress_sht '))
Drop INDEX Getfinancelogview.idx_prod_productprogress_sht
Go
Create UNIQUE CLUSTERED Index Idx_prod_productprogress_sht
On
Getfinancelogview (ID);

Operations for SQL Server views