---
title: "What is the difference between a check constraint and a rule?"  
description: "What is the difference between a check constraint and a rule?"  
author: "Sumit Kesarwani"  
published: 2014-03-15  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/1931/what-is-the-difference-between-a-check-constraint-and-a-rule  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# What is the difference between a check constraint and a rule?

Check constraints and rules limit the range of values that a user can enter into a column. Whereas check constraints apply only to the table for which you enter them, you can apply rules to multiple tables.

## Answers

### Answer by Sumit Kesarwani

Check constraints and rules limit the range of values that a user can enter into a column. Whereas check constraints apply only to the table for which you enter them, you can apply rules to multiple tables.


---

Original Source: https://www.mindstick.com/interview/1931/what-is-the-difference-between-a-check-constraint-and-a-rule

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