15.00 - 5507 Referential integrity constraints are not allowed with a WITH [NO] DATA clause. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

5507 Referential integrity constraints are not allowed with a WITH [NO] DATA clause.

Explanation:

When a WITH [NO] DATA clause is specified for a CREATE TABLE statement, REFERENCE constraints cannot be specified.

Generated By:

Syntaxer.

For Whom:

User.

Remedy:

Remove referential constraint and re-submit query.