SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE VIEW my_view
AS
SELECT 1 AS c;
SELECT * FROM my_view;

c

1

CREATE OR ALTER VIEW my_view
AS
SELECT 2 AS c;
SELECT * FROM my_view;

c

2