Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Designing and Creating Databases » Designing and creating your database » Tutorial: Creating a SQL Anywhere database


Lesson 5: Create relationships between tables using foreign keys

In this lesson, you learn about creating relationships between tables using foreign keys. You use the tables you created in the previous lessons of the Creating a SQL Anywhere tutorial for this lesson.

For information about designing relationships, see Entities and relationships.

To create a foreign key

  1. In the left pane of Sybase Central, double-click Tables.

  2. In the left pane, click the SalesOrders table to select it.

  3. In the right pane, select the Constraints tab.

  4. Choose File » New » Foreign Key.

  5. In the To Which Table Do You Want This Foreign Key To Refer list, select the Products table.

  6. In the What Do You Want To Name The New Foreign Key field, type ProductIDkey.

  7. Click Next and for Do You Want This Foreign Key To Reference The Primary Key Or A Unique Constraint choose Primary Key.

  8. In the Foreign Column list, click ProductID.

  9. Click Finish.

This completes this introductory section on creating relational databases.

For more information about designing databases, see Entities and relationships.

See also