Question

What is SCHEMABINDING a VIEW?

(a) Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view

(b) These are stored only in the Master database

(c) These types of view are defined by users on a specified schema

(d) These are used to show database self describing information

I got this question during an interview.

Origin of the question is Views topic in section Laying the Foundation of SQL Server

Answer 1

Right answer is (b) These are stored only in the Master database

The explanation is: SCHEMABINDING binds the view to the schema of the underlying table or tables. When SCHEMABINDING is specified, the base table or tables cannot be modified in a way that would affect the view definition.