SQL view with "with check option"

Question

I am currently reading the documentation from Microsoft about views and I am kind of confused on what I read about the "with check option." There isn't any examples provided in the documentation. Can someone make me a simple example? I understand easier with examples.

CHECK OPTION Forces all data modification statements executed against the view to follow the criteria set within select_statement. When a row is modified through a view, the WITH CHECK OPTION makes sure the data remains visible through the view after the modification is committed.

Answer 1

Let's understand using the following example

CREATE VIEW PortlandAreaAddresses_vw
AS
SELECT AddressID,
AddressLine1,
City,
StateProvinceID,
PostalCode,
ModifiedDate
FROM Person.Address
WHERE PostalCode LIKE ‘970%’
OR PostalCode LIKE ‘971%’
OR PostalCode LIKE ‘972%’
OR PostalCode LIKE ‘986[6-9]%’
WITH CHECK OPTION;

In this case, if you try to insert a record, CHECK OPTION will enforce to to follow the 4 rules specified for PostalCode

WHERE PostalCode LIKE ‘970%’
OR PostalCode LIKE ‘971%’
OR PostalCode LIKE ‘972%’
OR PostalCode LIKE ‘986[6-9]%’

That means you can't insert a PostalCode like '19970'