sql constraints Archives - {coding}Sight https://codingsight.com/tag/sql-constraints/ Blog for SQL Server DBAs and Developers Thu, 23 Sep 2021 10:53:07 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png sql constraints Archives - {coding}Sight https://codingsight.com/tag/sql-constraints/ 32 32 Create a Database Diagram Using dbForge Database ER Diagram Tool for SQL Server https://codingsight.com/create-a-database-diagram-using-dbforge-database-er-diagram-tool-for-sql-server/ Mon, 09 Nov 2020 15:34:12 +0000 https://codingsight.com/?p=10303 SQL Server database diagram is a graphical representation of database tables. It visualizes the database structure and allows you to understand the overall database schema and relations. It lets you also manage the database schema from the diagram page by creating and modifying database tables, columns, dependencies, indexes, constraints, and keys. Using SQL Server Management …

The post Create a Database Diagram Using dbForge Database ER Diagram Tool for SQL Server appeared first on {coding}Sight.

]]> Tutorial on SQL (DDL, DML) on the example of MS SQL Server dialect https://codingsight.com/tutorial-on-sql-ddl-dml-on-the-example-of-ms-sql-server-dialect/ Sun, 12 May 2019 23:30:30 +0000 https://codingsight.com/?p=6947 Introduction This tutorial includes information about SQL (DDL, DML) that I have gathered during my professional life. This is the minimum you need to know while working with databases. If there is a need to use complex SQL constructions, then usually I surf the MSDN library, which can be easily found on the internet. To …

The post Tutorial on SQL (DDL, DML) on the example of MS SQL Server dialect appeared first on {coding}Sight.

]]> The Difference Between Primary Key And Unique Key https://codingsight.com/the-difference-between-primary-key-and-unique-key/ Wed, 03 Apr 2019 20:28:32 +0000 https://codingsight.com/?p=6593 “What is the difference between a primary key constraint and a unique key constraint?” This is probably the most frequently-asked job interview question for database developers. In this article, we will try to answer it. Let’s start by looking at what primary and unique keys are, as well as at their similarities. Primary Key A …

The post The Difference Between Primary Key And Unique Key appeared first on {coding}Sight.

]]> Difference Between Inline and Out-of-Line Constraints https://codingsight.com/difference-between-inline-and-out-of-line-constraints/ Tue, 15 May 2018 11:52:19 +0000 http://codingsight.com/?p=4071 Constraints on tables and columns allow you to enforce the data quality. In SQL, there are two ways of creating constraints on a table: inline and out of line. In this article, I am going to explore these constraints and the advantages they have, as well as explain which one I recommend and why. What is …

The post Difference Between Inline and Out-of-Line Constraints appeared first on {coding}Sight.

]]> SQL Server: Useful Tips for Newbies https://codingsight.com/sql-server-useful-tips-for-newbies/ Wed, 29 Mar 2017 15:31:20 +0000 http://codingsight.com/?p=974 In this article, we will discuss typical errors that newbie developers may face with while designing T-SQL code. In addition, we will have a look at the best practices and some useful tips that may help you when working with SQL Server, as well as workarounds to improve performance. Contents: 1. Data Types 2. * …

The post SQL Server: Useful Tips for Newbies appeared first on {coding}Sight.

]]> Insight into SQL Server Unique Constraints https://codingsight.com/insight-into-sql-server-unique-constraints/ Thu, 23 Mar 2017 09:05:56 +0000 http://codingsight.com/?p=890 What are unique key constraints? A unique constraint is a rule that restricts column entries to unique. In other words, this type of constraints prevents inserting duplicates into a column. A unique constraint is one of the instruments to enforce data integrity in an SQL Server database. Since a table can have only one primary …

The post Insight into SQL Server Unique Constraints appeared first on {coding}Sight.

]]> CHECK Constraints in SQL Server https://codingsight.com/check-constraints-in-sql-server/ Fri, 27 Jan 2017 13:29:09 +0000 http://codingsight.com/?p=413 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 pitfalls you may encounter when using this type of SQL Server constraints. CHECK constraint basics CHECK constraints are simply conditional statements (predicates that return TRUE or FALSE) that refer to …

The post CHECK Constraints in SQL Server appeared first on {coding}Sight.

]]> Retrieving SQL Server Metadata with Help of T-SQL https://codingsight.com/retrieving-sql-server-metadata-with-help-of-tsql/ https://codingsight.com/retrieving-sql-server-metadata-with-help-of-tsql/#comments Mon, 12 Jan 2015 07:57:54 +0000 http://codingsight.com/?p=121 This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and catalog views. Metadata queries are really helpful in discovering information for a given database schema. You can copy all the T-SQL scripts that are listed in this article and use for your own …

The post Retrieving SQL Server Metadata with Help of T-SQL appeared first on {coding}Sight.

]]> https://codingsight.com/retrieving-sql-server-metadata-with-help-of-tsql/feed/ 2