Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Column '%1' found in more than one table -- need a correlation name Next Page

Column '%1' in foreign key has a different definition than primary key

Item

Value

Constant

SQLE_INVALID_FOREIGN_KEY_DEF

ODBC 2 State

42000

ODBC 3 State

42000

Parameter 1

Name of the problem column.

Severity

16

SQLCODE

-113

SQLSTATE

53030

Sybase error code

1721

Probable cause

The data type of the column in the foreign key is not the same as the data type of the column in the primary key. Change the definition of one of the columns using ALTER TABLE.