alter view.sql

本程序中即有讲义

use pubs
go
CREATE VIEW All_authors (au_fname, au_lname, address, city, zip)
AS 
SELECT au_fname, au_lname, address, city, zip
FROM authors
GO

select * from All_authors
go
ALTER VIEW All_authors (au_fname, au_lname, address, city, zip)
AS 
SELECT au_fname, au_lname, address, city, zip
FROM pubs..authors
WHERE state = 'UT'
GO
select * from All_authors