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 specified schema
D. These are used to show database self describing information
Answer:A
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 specified schema D. These are used to show database self describing information
Explanation: 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.