alter view.sql

来自「本程序中即有讲义」· SQL 代码 · 共 17 行

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