Server Error Messages 13900 - 13999


Warning: a default (object id %ld) is defined on column ’%.*s’ being modified. Check the validity of the default value after this ALTER TABLE operation. 
Warning: a rule or constraint is defined on column ’%.*s’ being modified. Verify the validity of rules and constraints after this ALTER TABLE operation. 
 Warning: Column ’%.*s’ being modified is a key in one or more indexes. Verify the validity of these indexes after this ALTER TABLE operation. 
 Warning: primary or foreign keys are defined on column ’%.*s’ being modified. Verify the validity of the RI constraint after this ALTER TABLE operation. 
 Warning: A logical RI constraint, using sp_primarykey/sp_foreignkey exists on column ’%.*s’ being modified. Verify the validity of the logical RI constraint after this ALTER TABLE operation. 
Warning: no columns to drop, add or modify. ALTER TABLE ’%.*s’ was aborted. 
ALTER TABLE ’%.*s’ failed. You cannot add new non-NULL text/image column ’%.*s’. Such columns may only be added as NULL columns. 
 ALTER TABLE ’%.*s’ failed. You cannot modify column ’%.*s’ to text/image type. 
 ALTER TABLE ’%.*s’ failed. You cannot add off-row Java/text/image column in conjunction with either dropping or modifying such a column. 
ALTER TABLE ’%.*s’ failed. You cannot drop text/image column ’%.*s’ in conjunction with modifying column ’%.*s’ to text/image type. 
Warning: since data is not copied when altering table ’%.*s’, the specified ’exp_row_size’ value will not be honored. Use sp_chgattribute to change the ’exp_row_size’ value after this ALTER TABLE operation. 
 Warning: when modifying column ’%.*s’, user specified NULL type overrides the NULL type of user defined datatype ’%.*s’. 
 Warning: when modifying column ’%.*s’, the NULL type of the user-defined datatype ’%.*s’ will be applied to the column. 
Warning: column ’%.*s’ is referenced by one or more rules or constraints. Verify the validity of the rules/constraints after this ALTER TABLE operation. 
ALTER TABLE ’%.*s’ failed. You cannot drop column ’%.*s’ which is referenced in one or more rules/constraints. Drop the rules/constraints before dropping the column. 
 ALTER TABLE failed. You cannot add table-level constraints when the operation on table ’%.*s’ requires data copy. Add the constraints in a separate ALTER TABLE statement. 
 ALTER TABLE ’%.*s’ failed. You cannot add column-level constraints, such as referential integrity or primary key/unique constraints, when the operation requires data copy. 
 ALTER TABLE ’%.*s’ failed. You cannot alter a data-only locked partitioned table with a clustered index when the operation requires data copy. Drop the index and try again. 
 ALTER TABLE ’%.*s’ failed. Default cannot be an expression when adding non-NULL column ’%.*s’. Use a default value instead. 
 ALTER TABLE ’%.*s’ failed because the table definition has been changed. 
 ALTER TABLE ’%.*s’ failed. Lock change operation cannot be supported with other operations that do not require data copy. 
ALTER TABLE ’%.*s’ failed. You cannot drop column ’%.*s’ on which a primary/foreign key constraint is defined using sp_primarykey or sp_foreignkey. Drop the key definitions before dropping the column. 
ALTER TABLE ’%.*s’ failed. You cannot modify timestamp column ’%.*s’. 
ALTER TABLE ’%.*s’ failed. You cannot modify the datatype of column ’%.*s’ to timestamp. 
ALTER TABLE ’%.*s’ failed. You cannot modify a primary key column to NULL. 
 Warning: ALTER TABLE operation did not affect column ’%.*s’. 
ALTER TABLE ’%.*s’ failed. A table with a clustered index cannot be altered if the operation includes a lock scheme change. 
 ALTER TABLE ’%.*s’ failed. You cannot add an identity column to a partitioned table when the operation requires data copy. 
 ALTER TABLE ’%.*s’ failed. You cannot specify a default clause when adding identity column ’%.*s’. 
ALTER TABLE ’%.*s’ failed. You cannot drop identity column ’%.*s’ when ’identity_insert’ is on. Set this option off before dropping the identity column. 
 The procedure ’%.*s’ contains an ALTER TABLE statement requiring data copy. This should be the only statement in the procedure. 
 ALTER TABLE ’%.*s’ failed. Internal error detected while trying to update SYSCOLUMNS with text/image replication status. 
 ALTER TABLE ’%.*s’ failed. You cannot modify column ’%.*s’ to type ’%.*s’ which has identity property. 
 ALTER TABLE ’%.*s’ failed. You cannot modify identity column ’%.*s’ whose datatype is user-defined. 
ALTER TABLE ’%.*s’ failed. You cannot modify column ’%.*s’. You cannot modify a Java column or modify a column to type Java ADT. 
 ALTER TABLE ’%.*s’ failed. You cannot add new non-null Java column ’%.*s’. Such columns may only be added as NULL columns. 
 ALTER TABLE ’%.*s’ failed. You cannot alter a partitioned table that has Java columns when the operation requires data copy. To alter the schema, unpartition the table, then repartition it. 
 Warning: The schema for table ’%.*s’ has changed. Drop and re-create each trigger on this table that uses the ’if update(column_name)’ clause. 
ALTER TABLE ’%.*s’ failed. You cannot drop column ’%.*s’ because it is part of the partition key.
ALTER TABLE ’%.*s’ failed. You cannot modify column ’%.*s’ because it is part of the partition key.
One or more column names in the specified table contain reserved words or special characters, for example ’%.*s’. Set the QUOTED_IDENTIFIER option to handle the column(s) and re-run the command.

Number	Severity	Text and Explanation
13900	10	Warning: a default (object id %ld) is defined on column ’%.s’ being modified. Check the validity of the default value after this ALTER TABLE operation. Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13901	10	Warning: a rule or constraint is defined on column ’%.s’ being modified. Verify the validity of rules and constraints after this ALTER TABLE operation. Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13902	10	Warning: Column ’%.s’ being modified is a key in one or more indexes. Verify the validity of these indexes after this ALTER TABLE operation. Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13903	10	Warning: primary or foreign keys are defined on column ’%.s’ being modified. Verify the validity of the RI constraint after this ALTER TABLE operation. Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13904	10	Warning: A logical RI constraint, using sp_primarykey/sp_foreignkey exists on column ’%.s’ being modified. Verify the validity of the logical RI constraint after this ALTER TABLE operation. Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13905	10	Warning: no columns to drop, add or modify. ALTER TABLE ’%.s’ was aborted. Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13906	10	ALTER TABLE ’%.s’ failed. You cannot add new non-NULL text/image column ’%.s’. Such columns may only be added as NULL columns. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13907	16	ALTER TABLE ’%.s’ failed. You cannot modify column ’%.s’ to text/image type. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13908	16	ALTER TABLE ’%.s’ failed. You cannot add off-row Java/text/image column in conjunction with either dropping or modifying such a column. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13909	16	ALTER TABLE ’%.s’ failed. You cannot drop text/image column ’%.s’ in conjunction with modifying column ’%.s’ to text/image type. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13910	10	Warning: since data is not copied when altering table ’%.s’, the specified ’exp_row_size’ value will not be honored. Use sp_chgattribute to change the ’exp_row_size’ value after this ALTER TABLE operation. Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13911	10	Warning: when modifying column ’%.s’, user specified NULL type overrides the NULL type of user defined datatype ’%.s’. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13912	10	Warning: when modifying column ’%.s’, the NULL type of the user-defined datatype ’%.s’ will be applied to the column. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13913	10	Warning: column ’%.s’ is referenced by one or more rules or constraints. Verify the validity of the rules/constraints after this ALTER TABLE operation. Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13914	16	ALTER TABLE ’%.s’ failed. You cannot drop column ’%.s’ which is referenced in one or more rules/constraints. Drop the rules/constraints before dropping the column. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13915	16	ALTER TABLE failed. You cannot add table-level constraints when the operation on table ’%.s’ requires data copy. Add the constraints in a separate ALTER TABLE statement. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13916	16	ALTER TABLE ’%.s’ failed. You cannot add column-level constraints, such as referential integrity or primary key/unique constraints, when the operation requires data copy. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13917	16	ALTER TABLE ’%.s’ failed. You cannot alter a data-only locked partitioned table with a clustered index when the operation requires data copy. Drop the index and try again. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13918	16	ALTER TABLE ’%.s’ failed. Default cannot be an expression when adding non-NULL column ’%.s’. Use a default value instead. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13919	16	ALTER TABLE ’%.s’ failed because the table definition has been changed. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13920	16	ALTER TABLE ’%.s’ failed. Lock change operation cannot be supported with other operations that do not require data copy. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13921	16	ALTER TABLE ’%.s’ failed. You cannot drop column ’%.s’ on which a primary/foreign key constraint is defined using sp_primarykey or sp_foreignkey. Drop the key definitions before dropping the column. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13922	16	ALTER TABLE ’%.s’ failed. You cannot modify timestamp column ’%.s’. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13923	16	ALTER TABLE ’%.s’ failed. You cannot modify the datatype of column ’%.s’ to timestamp. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13924	16	ALTER TABLE ’%.s’ failed. You cannot modify a primary key column to NULL. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13925	10	Warning: ALTER TABLE operation did not affect column ’%.s’. Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13926	16	ALTER TABLE ’%.s’ failed. A table with a clustered index cannot be altered if the operation includes a lock scheme change. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13927	16	ALTER TABLE ’%.s’ failed. You cannot add an identity column to a partitioned table when the operation requires data copy. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13928	16	ALTER TABLE ’%.s’ failed. You cannot specify a default clause when adding identity column ’%.s’. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13929	16	ALTER TABLE ’%.s’ failed. You cannot drop identity column ’%.s’ when ’identity_insert’ is on. Set this option off before dropping the identity column. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13930	16	The procedure ’%.s’ contains an ALTER TABLE statement requiring data copy. This should be the only statement in the procedure. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13931	16	ALTER TABLE ’%.s’ failed. Internal error detected while trying to update SYSCOLUMNS with text/image replication status. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13932	16	ALTER TABLE ’%.s’ failed. You cannot modify column ’%.s’ to type ’%.s’ which has identity property. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13933	16	ALTER TABLE ’%.s’ failed. You cannot modify identity column ’%.s’ whose datatype is user-defined. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13934	16	ALTER TABLE ’%.s’ failed. You cannot modify column ’%.s’. You cannot modify a Java column or modify a column to type Java ADT. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13935	16	ALTER TABLE ’%.s’ failed. You cannot add new non-null Java column ’%.s’. Such columns may only be added as NULL columns. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13936	16	ALTER TABLE ’%.s’ failed. You cannot alter a partitioned table that has Java columns when the operation requires data copy. To alter the schema, unpartition the table, then repartition it. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
13937	10	Warning: The schema for table ’%.s’ has changed. Drop and re-create each trigger on this table that uses the ’if update(column_name)’ clause. Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
13938	16	ALTER TABLE ’%.s’ failed. You cannot drop column ’%.s’ because it is part of the partition key. Explanation: Command failed. See the command syntax in the Reference Manual for details.
13939	16	ALTER TABLE ’%.s’ failed. You cannot modify column ’%.s’ because it is part of the partition key. Explanation: Command failed. See the command syntax in the Reference Manual for details.
13940	16	One or more column names in the specified table contain reserved words or special characters, for example ’%.s’. Set the QUOTED_IDENTIFIER option to handle the column(s) and re-run the command. Explanation:* Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.