Please enable JavaScript to view this site.

Altova DatabaseSpy 2020 Professional 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

© 2019 Altova GmbH