---
title: "What is the WITH CHECK OPTION in view and what is its purspose?"  
description: "What is the WITH CHECK OPTION in view and what is its purspose?"  
author: "Sushant Mishra"  
published: 2017-09-14  
updated: 2020-09-19  
canonical: https://www.mindstick.com/interview/23297/what-is-the-with-check-option-in-view-and-what-is-its-purspose  
category: "database"  
tags: ["sql server", "sql server 2008", "sql server 2012"]  
reading_time: 1 minute  

---

# What is the WITH CHECK OPTION in view and what is its purspose?

It is the view check statement. The purpose of the WITH CHECK OPTION is to verify that all select and update satisfies the view condition or not, if they not satisfy the condition it return an error

## Answers

### Answer by Sushant Mishra

It is the view check statement. The purpose of the WITH CHECK OPTION is to verify that all select and update satisfies the view condition or not, if they not satisfy the condition it return an error


---

Original Source: https://www.mindstick.com/interview/23297/what-is-the-with-check-option-in-view-and-what-is-its-purspose

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.