You use a Microsoft Azure SQL DataBase instance. The instance contains a table named Customers that has columns named Id, Name, and IsPriority.
You need to create a view named VwPriorityCustomers that:
* returns rows from Customer that have a value of True in the IsPriority column, and
* does not allow columns to be altered or dropped in the underlying table.
Which Transact-SQL statement shoul you run?
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.