Please enable JavaScript to view this site.

Altova DatabaseSpy 2020 Enterprise Edition

In the previous section, you have added tables using both SQL statements and the Design Editor. In this section of the tutorial, you will learn how to create database constraints, using the Design Editor. Specifically, you will learn how to do the following:


Define a unique constraint for a column

Add check constraints on column and table level

Provide columns with default values

Manually create relationships between tables

Use SQL scripts to create foreign key relationships

© 2020 Altova GmbH