Altova DatabaseSpy 2023 Professional Edition

Defining Constraints

Home Prev Top Next

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

© 2017-2023 Altova GmbH