SQL Server 2022

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

CREATE TABLE dbo.Test
(
    A    CHAR(1) NOT NULL  ,
    B    CHAR(1) NOT NULL  ,
    Num  INT NOT NULL   
);

INSERT INTO dbo.Test(A, B, Num) 
  VALUES ('A', 'B', 10);
1 rows affected

CREATE OR ALTER VIEW dbo.View1
  AS 
    SELECT * 
    FROM  dbo.Test;
CREATE OR ALTER VIEW dbo.View2
  AS 
    SELECT A,B,Num 
    FROM  dbo.Test;
ALTER TABLE dbo.Test DROP COLUMN A ;

ALTER TABLE dbo.Test 
        ADD A CHAR(1) NOT NULL DEFAULT 'C',
            D CHAR(1) NOT NULL DEFAULT 'D';
SELECT  * FROM dbo.View1


A
B
Num


B
10
C


SELECT  * FROM dbo.View2


A
B
Num


C
B
10