SQL Server　ビュー定義変更

基本文型

ALTER VIEW [ ビュー名 ]
AS
	[ SELECT ステートメント ]

実行文

CREATE VIEW V_test
AS
    SELECT  
        1 as c1,
        2 as c2

GO

select * from V_test

GO

ALTER VIEW V_test
AS
    SELECT  
        1 as c1,
	2 as c2,
	'犬塚' as c3

GO

select * from V_test