---
title: "Define and discuss data constraints."  
description: "Define and discuss data constraints."  
author: "Sumit Kesarwani"  
published: 2014-08-24  
updated: 2020-09-18  
canonical: https://www.mindstick.com/interview/1996/define-and-discuss-data-constraints  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# Define and discuss data constraints.

Data constraints on a column are the limits put on the values the data can have.

There are four types of data constraints:

(1) domain constraints, which define a limited set of values for the column,

(2) range constraints, which specify that the values must fall within a certain range,

(3) intrarelation constraints, which define what values the column can have based on values of other columns in the same table, and

(4) interrelation constraints, which define values the column can have based on values of columns in other tables.

## Answers

### Answer by Sumit Kesarwani

Data constraints on a column are the limits put on the values the data can have.

There are four types of data constraints:

(1) domain constraints, which define a limited set of values for the column,

(2) range constraints, which specify that the values must fall within a certain range,

(3) intrarelation constraints, which define what values the column can have based on values of other columns in the same table, and

(4) interrelation constraints, which define values the column can have based on values of columns in other tables.


---

Original Source: https://www.mindstick.com/interview/1996/define-and-discuss-data-constraints

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