Table cannot have two primary keys

Contents

Index

Table already has a primary key

Table in use

ASA Error Messages
Database Error Messages
Alphabetic list of error messages

Table cannot have two primary keys

Item	Value
SQLCODE	-126
Constant	SQLE_PRIMARY_KEY_TWICE
SQLSTATE	52W05
Sybase error code	1923
ODBC 2 State	42000
ODBC 3 State	42000

Probable cause

You specified the primary key twice in a CREATE TABLE statement.

Contents

Index

Table already has a primary key

Table in use