Before you begin...

You must have at least one of the following privileges to create a table:

• CREATETAB privilege on the database and either:

  • IMPLICIT_SCHEMA authority on the database if the implicit or explicit schema name of the table does not exist

  • CREATEIN privilege on the schema if the schema name of the table exists

• SYSADM or DBADM authority

To define a foreign key, you must have at least one of the following privileges on the foreign table:

• REFERENCES privilege on the table
• CONTROL privilege on the table
• SYSADM or DBADM authority

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]