SQL Server: View

--View:

select*from Student;

create view vw_ViewStudent with schemabinding as

select rn,age,status from dbo.Student

where Age>=20;

alter view vw_ViewStudent with encryption,schemabinding as

select top(99.9999) percent rn,age,status from dbo.Student

where Age>=20

order by age

-- group by rn,Age,status

with check option;

exec sp_helptext 'vw_ViewStudent';

update vw_ViewStudent set Age=18 where RN=1;

alter table Student alter column age float;

create unique clustered index uci on vw_ViewStudent(rn);

drop index vw_ViewStudent.uci;