Error 540



Message text

Schema for table '%.*s' has changed since compilation of this query. Please re-execute query.


A table’s schema consists of column definitions along with any indices, constraints, rules, defaults and so on. A change to any of these elements (for example, creating or dropping a constraint) constitutes a change in the table’s schema.

Query processing involves these basic steps:

Error 540 is raised:

Error 540 is not a serious error; however, it may prevent you from running some ad hoc queries.


If the error occurred when creating and inserting to a table with a primary key constraint in the same batch, contact Sybase Technical Support to help you upgrade to a version in which the problem is resolved.

If the error occurred in a different scenario:

Versions in which this error is raised

All versions