SIMULATION
You need to create a view named Sales.uv_CustomerFullNames. The view must display the FirstName and LastName fields from a table named Sales.Customers. The view must also prevent the underlying structure of the customer table from being changed.
Part of the correct Transact-SQL has been provided in the answer area below. Enter the Transact-SQL in the answer area that resolves the problem and meets the stated goals or requirements. You can add Transact-SQL within the Transact-SQL segment that has been provided as well as below it.


Use the Check Syntax button to verify your work. Any syntax or spelling errors will be reported by line and character position.
Correct Answer:
Please review the explanation part for this answer
Explanation/Reference:
Explanation:
WITH SCHEMABINDING
Add WITH SCHEMABINDING to the first line to get:
CREATE VIEWsales.uv_CustomerFullNames WITH SCHEMABINDING
AS SELECT
FirstName,
LastName
FROM Sales.Customers
When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying tables or views. It means that as long as that schemabound object exists as a schemabound object (ie you don't remove schemabinding) you are limited in changes that can be made to the tables or views that it refers to.
References:https://sqlstudies.com/2014/08/06/schemabinding-what-why/