Tag: sql constraints

Create a Database Diagram Using dbForge Database ER Diagram Tool for SQL Server

Tools & technologies, Utilities & Extensions

SQL Server database diagram is a graphical representation of database tables. It visualizes the...
Read More

Tutorial on SQL (DDL, DML) on the example of MS SQL Server dialect

Database administration, Database Optimization & Structure

Introduction This tutorial includes information about SQL (DDL, DML) that I have gathered during my professional life. This is the minimum...
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

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...
Read More

SQL Server: Useful Tips for Newbies

Database development

In this article, we will discuss typical errors that newbie developers may face with while designing T-SQL code. In addition, we will have...
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 unique. In other words, this type of...
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...
Read More

Retrieving SQL Server Metadata with Help of T-SQL

Languages & Coding, T-SQL • 2 Comments

This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and...
Read More
Close