Error 2714



Message text

There is already an object named '%.*s' in the database.


This error occurs when Adaptive Server tries to create an object that already exists.

Error 2714 can occur:

When using temporary tables:


Make sure the name of the object you are trying to create does not already exist.

If you have stored procedures that create objects, make sure there is a check for the existence of the object in the stored procedure (before it is created). If you want to re-create an object within a stored procedure, drop the object before you re-create it.

Additional information

Refer to the Reference Manual: Commands for information about creating and dropping objects.

Versions in which this error is raised

All versions