What is the replacement for the CREATE OR REPLACE VIEW command (which I could use in MySQL) in MS SQL Server?
In SQL Server you need to change
ALTER - the command will work the same as in MySQL.
CREATE OR ALTER VIEW [view_name] AS SELECT [column1], [column2], [columnN] FROM [table_name] WHERE condition;
You can also check out the article I made to see a practical example for better understanding: