Constraints

How to Create a Table with Multiple Foreign Keys and Not Get Confused

Constraints, Database development, Tables

Understanding Table Relations SQL server adds foreign keys to implement relations between tables in...
Read More

SQL FOREIGN KEY CONSTRAINT: The Ultimate, Easy Guide for Newbies

Constraints, Database development

Newbie? Then an SQL foreign key may be foreign to you. You may have heard different opinions about SQL foreign keys. If you haven’t, soon...
Read More

The Difference Between Primary Key And Unique Key

Constraints, Database development

“What is the difference between a primary key constraint and a unique key constraint?” This is probably the most frequently-asked job...
Read More

SQL Server Bulk Insert – Part 2

Constraints, Database development, Triggers

In the previous part of this article, we discussed how to import CSV files to SQL Server with the...
Read More

Difference Between Inline and Out-of-Line Constraints

Constraints, Database development

Constraints on tables and columns allow you to enforce the data quality. In SQL, there are two ways of creating constraints on a...
Read More

Counting references to a record in a table via Foreign Keys

Constraints, Database development

I have recently needed to solve the task for my own purpose: to calculate the number of external records linked by a foreign key for each...
Read More

Insight into SQL Server Unique Constraints

Constraints, Database development

What are unique key constraints? A unique constraint is a rule that restricts column entries to...
Read More

CHECK Constraints in SQL Server

Constraints, Database development

In this article, we will talk about CHECK constraints. We will see how to add CHECK constraints to SQL Server table columns and discuss the...
Read More
Close