Views

Question 0

3 types of views

Answer 0

DAV

Data views - used to examine and manipulate data from base tables

Aggregate views - displays information that is a result of aggregating data. This view is not editable and best used for reports or statistical data.

Validation views - used to implement data integrity.

Question 1

What is it?

Answer 1

It’s a virtual table
The contents are defined by a query
Data can be modified in most views

Question 2

Create View Syntax

Answer 2

CREATE VIEW nameofview WITH SCHEMABINDING
AS
SELECT fields
FROM SCHEMA.tbl
WHERE
GO;

Question 3

Deleting view syntax

Answer 3

DROP VIEW fullyqualifiedtblname

Question 4

Differences between VIEW & ITVF (inline table value function

Answer 4

Both are single statement definition
Both return a tbl dataset.

Differences:
ITVF can accept parameter(s)
VIEWS READ/WRITE to DBase
ITVF READ DBase only 
VIEWS can be indexed (indexed view)

Question 5

Alter view syntax

Answer 5

ALTER VIEW nameofview 
AS
SELECT 
FROM
WHERE
GO