How to change an SQL Server View

Question

I have some Views on Sql Server that were implemented by other people ,but they didn’t leave any documentation or scripts, I believe it is possible to access to change and maintain them? But I don’t know how to do that. Note: The view will be triggered by a user in Excel!

Answer 1

Use as an example the query below.

ALTER VIEW [dbo].[VIEW_EXEMPLO]
AS
    SELECT 1
GO

Or follow this step by step.

1. Right click on the view;
2. Click on Script View as
3. Click on ALTER To