Check Constraint in MS SQL Server

Last Updated : 26 Aug, 2020

Check Constraint :
It is used alongside relational operators to check whether a value satisfies the condition or not (boolean). If the condition is satisfied, the boolean expression sets to True otherwise False. The check constraint does not have a specific syntax. It is used along with the create table syntax.

Syntax :

Create table Marks   name varchar2(30),   rollnumber number primary key,   marks int check (marks<=75)

A table named Student is created along with the condition that marks must not be greater than 75. A user inserts a few values as shown below –

Table – Marks

Name	Rollnumber	Marks
Aisha	111	60
Naina	112	73

The values are inserted as per the conditions mentioned in the create table syntax. The user tries inserting a few more values yet errors occur as shown below –

Example-1:

Insert into Student   values('Maya', '117', '80')

Output –
The value results in an error as the value is greater than 75.

Example-2:

Insert into Student   values('Maya' '111', '74')

Output –
An error is displayed. This is due to the primary key used for rollnumber. Primary key forbids the use of duplicates in a table.

Check constraint in case of NULL :

Insert into Student   values('Riya', '112', 'NULL')

Output –
In SQL, NULL is used incase of unknown value. Therefore it is considered as False.

Create Database in MS SQL Server

mangalgiaishwarya2

Improve

Article Tags :

Similar Reads

Joins in MS SQL Server

A database comprises tables and each table in case of RDBMS is called a relation. Let us consider a sample database named University and it has two tables named Student and Marks. If a user wants to transfer a certain set of rows, insert into select statement is used along with the query. But if a u

2 min read

Find Duplicates in MS SQL Server

Finding duplicate values in a database is a common task when managing data integrity. In SQL, several methods can be employed to identify and handle duplicate entries. In this article, We will explore two effective techniques for locating duplicates using SQL queries: the GROUP BY clause and the ROW

4 min read

SQL Server CRUD Operations

Transact SQL Statements can be classified into DDL, DML, and DCL Statements and in terms of Computer Programming, DML statements can be referred to as CRUD operations. In this article, we can see in more detail the CRUD operations and how we can use those statements in SQL Server with examples. CRUD

11 min read

Create Database in MS SQL Server

Databases in Microsoft SQL Server are crucial for managing data, categorized into system databases, which are auto-created and user databases, created by users. In this article, We will learn about the basics of system and user databases along with methods for creating and managing them using T-SQL

6 min read

COUNT() Function in SQL Server

The COUNT() function in SQL Server is a fundamental aggregate function used to determine the number of rows that match a specific condition. Counting rows provides valuable insights into data sets such as the total number of records, distinct values, or records meeting certain criteria. In this arti

3 min read

Introduction of MS SQL Server

Data is a collection of facts and figures and we have humungous data available to the users via the internet and other sources. To manipulate the data, Structured Query Language (SQL) in short has been introduced years ago. There are different versions of SQL available in the market provided by diff

2 min read

Self Join and Cross Join in MS SQL Server

Prerequisite - Introduction of MS SQL Server 1. Self Join : Self-join allows us to join a table itself. It is useful when a user wants to compare the data (rows) within the same table. Syntax - select select_list from T t1 [Inner|Left] Join on T t2 on join_predicate. Here T refers to the table we us

2 min read

SQL DROP CONSTRAINT

In SQL, constraints are used to ensure data integrity and define rules for the data in our database tables. These rules include ensuring uniqueness, maintaining referential integrity, and validating data with conditions. By applying constraints such as primary key, foreign key, unique, and check con

4 min read

SQL | Constraints

SQL constraints are essential elements in relational database design that ensure the integrity, accuracy, and reliability of the data stored in a database. By enforcing specific rules on table columns, SQL constraints help maintain data consistency, preventing invalid data entries and optimizing que

5 min read

Delete Database in MS SQL Server

Prerequisite â€“ Introduction of MS SQL Server and Create Database in MS SQL Server System databases can't be deleted, only user databases could be deleted. Data and log files will automatically be deleted from disk with database deletion. To delete a database, the below methods could be used â€“ SQL Se

1 min read