Defining Constraints
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