View in sql server

Referred as "Virtual Table"
Can not store data (except for indexed views) rather than only referto data present in table.

e.g. Create View vwsample
[optional]
With Encryption OR
With Schemabinding
[/optional]
AS

Select Cid, CName FRom Customer

GO

With Encryption - You can see view query (its encrypted)
With Schemabinding - You are not able to alter table on which it's created.

0 comments: