Table of Contents

Search

  1. About the Data Vault Message Reference
  2. Data Definition Language Errors
  3. Data Vault Repository Service Exit Codes
  4. Load Balancer and Administration Errors
  5. Data Vault Repository Administration CLI Errors
  6. Data Vault SQL Tool Messages
  7. Data Vault Loader Messages

Data Vault Message Reference

Data Vault Message Reference

J 0201

J
0201

Invalid unique constraint - column repeated in definition
This message appears when a CREATE TABLE or ALTER TABLE statement attempts to include the same column in more than one UNIQUE constraint, or in one PRIMARY KEY constraint and one or more UNIQUE constraints, within the same statement. A column may participate in at most one UNIQUE constraint; if a column participates in a UNIQUE constraint, it cannot subsequently participate in a primary key.
This message is also generated when the same column name is repeated in a UNIQUE constraint definition in a CREATE TABLE or ALTER TABLE statement. A particular column name can be included only once in a table constraint definition.

0 COMMENTS

We’d like to hear from you!