SQL Server2000创建视图

Create VIEW [ < database_name > .] [ < owner > .] view_name [ ( column [ ,...n ] ) ] 
[ WITH < view_attribute > [ ,...n ] ]
AS 
select_statement 
[ WITH CHECK OPTION ] 

< view_attribute > ::=
    { ENCRYPTION | SCHEMABINDING | VIEW_METADATA }

--select * from users
create view users as
select top 20 * from union_user