A View is a collection of one or more tables. A View can have whole table data or selected rows depends on conditions applied. A View is similar to a table but provide more functionality as compared to tables.
A View provide the following features:
- Select, Insert, Update, delete can be applied on View.
- Any changes to view will be updated in the corresponding tables.
- A View can be drop with the Drop Command.
- Indexing can be applied on View.
Syntax:
Create View [Schema_Name].[View_Name] AS SELECT column_name(s) FROM table_name WHERE condition