Altova DatabaseSpy 2024 Enterprise 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

© 2018-2024 Altova GmbH