Create a Database Diagram Using dbForge Database ER Diagram Tool for SQL Server
SQL Server database diagram is a graphical representation of database tables. It visualizes the...
Tutorial on SQL (DDL, DML) on the example of MS SQL Server dialect
Introduction This tutorial includes information about SQL (DDL, DML) that I have gathered during my professional life. This is the minimum...
The Difference Between Primary Key And Unique Key
“What is the difference between a primary key constraint and a unique key constraint?” This is probably the most frequently-asked job...
Difference Between Inline and Out-of-Line Constraints
Constraints on tables and columns allow you to enforce the data quality. In SQL, there are two...
SQL Server: Useful Tips for Newbies
In this article, we will discuss typical errors that newbie developers may face with while designing T-SQL code. In addition, we will have...
Insight into SQL Server Unique Constraints
What are unique key constraints? A unique constraint is a rule that restricts column entries to unique. In other words, this type of...
CHECK Constraints in SQL Server
In this article, we will talk about CHECK constraints. We will see how to add CHECK constraints to...
Retrieving SQL Server Metadata with Help of T-SQL
This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and...
