Constraints

Constraint naming syntax

Both Informix^® and Sybase ASE support primary key, unique, foreign key, default and check constraints. But Sybase ASE does not support constraint naming syntax:

CREATE TABLE emp (
   emp_code CHAR(10) UNIQUE CONSTRAINT pk_emp,
   ... )

Solution: Constraint naming syntax

The database interface does not convert constraint naming expressions when creating tables from BDL programs. Review the database creation scripts to adapt the constraint naming clauses for Sybase ASE.