SQL state list
The following table lists the SQLSTATE classes and individual SQLSTATE codes.
The following table lists the SQLSTATE classes and individual SQLSTATE codes.
| SQLState | Description | Details |
|---|---|---|
| Class 00—Successful Completion | ||
| 00000 | SUCCESSFUL_COMPLETION | associated error messages |
| Class 01—Warning | ||
| 01000 | WARNING | associated warning messages |
| 01003 | WARNING_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION | |
| 01004 | WARNING_STRING_DATA_RIGHT_TRUNCATION | associated warning messages |
| 01006 | WARNING_PRIVILEGE_NOT_REVOKED | associated warning messages |
| 01007 | WARNING_PRIVILEGE_NOT_GRANTED | associated warning messages |
| 01008 | WARNING_PRIVILEGE_ALREADY_GRANTED | |
| 01009 | WARNING_PRIVILEGE_ALREADY_REVOKED | associated warning messages |
| 0100C | WARNING_DYNAMIC_RESULT_SETS_RETURNED | |
| 01V01 | WARNING_DEPRECATED_FEATURE | associated warning messages |
| 01V02 | WARNING_QUERY_RETRIED | |
| Class 02—No Data | ||
| 02000 | NO_DATA | associated error messages |
| 02001 | NO_ADDITIONAL_DYNAMIC_RESULT_SETS_RETURNED | |
| Class 03—SQL Statement Not Yet Complete | ||
| 03000 | SQL_STATEMENT_NOT_YET_COMPLETE | |
| Class 08—Client Connection Exception | ||
| 08000 | CONNECTION_EXCEPTION | associated error messages |
| 08001 | SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION | associated error messages |
| 08003 | CONNECTION_DOES_NOT_EXIST | associated error messages |
| 08004 | SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION | associated error messages |
| 08006 | CONNECTION_FAILURE | associated error messages |
| 08007 | TRANSACTION_RESOLUTION_UNKNOWN | |
| 08V01 | PROTOCOL_VIOLATION | associated error messages |
| Class 09—Triggered Action Exception | ||
| 09000 | TRIGGERED_ACTION_EXCEPTION | associated error messages |
| Class 0A—Feature Not Supported | ||
| 0A000 | FEATURE_NOT_SUPPORTED | associated error messages |
| 0A005 | PLAN_TO_SQL_NOT_SUPPORTED | associated error messages |
| Class 0B—Invalid Transaction Initiation | ||
| 0B000 | INVALID_TRANSACTION_INITIATION | associated error messages |
| Class 0F—Locator Exception | ||
| 0F000 | LOCATOR_EXCEPTION | |
| 0F001 | L_E_INVALID_SPECIFICATION | |
| Class 0L—Invalid Grantor | ||
| 0L000 | INVALID_GRANTOR | |
| 0LV01 | INVALID_GRANT_OPERATION | associated error messages |
| Class 0P—Invalid Role Specification | ||
| 0P000 | INVALID_ROLE_SPECIFICATION | |
| Class 20—Case Not Found | ||
| 20000 | CASE_NOT_FOUND | associated error messages |
| Class 21—Cardinality Violation | ||
| 21000 | CARDINALITY_VIOLATION | associated error messages |
| Class 22—Data Exception | ||
| 22000 | DATA_EXCEPTION | associated error messages |
| 22001 | STRING_DATA_RIGHT_TRUNCATION | associated error messages |
| 22002 | NULL_VALUE_NO_INDICATOR_PARAMETER | |
| 22003 | NUMERIC_VALUE_OUT_OF_RANGE | associated error messages |
| 22004 | NULL_VALUE_NOT_ALLOWED | associated error messages |
| 22005 | ERROR_IN_ASSIGNMENT | |
| 22007 | INVALID_DATETIME_FORMAT | associated error messages |
| 22008 | DATETIME_FIELD_OVERFLOW | associated error messages |
| 22009 | INVALID_TIME_ZONE_DISPLACEMENT_VALUE | associated error messages |
| 2200B | ESCAPE_CHARACTER_CONFLICT | associated error messages |
| 2200C | INVALID_USE_OF_ESCAPE_CHARACTER | |
| 2200D | INVALID_ESCAPE_OCTET | associated error messages |
| 2200F | ZERO_LENGTH_CHARACTER_STRING | |
| 2200G | MOST_SPECIFIC_TYPE_MISMATCH | |
| 22010 | INVALID_INDICATOR_PARAMETER_VALUE | |
| 22011 | SUBSTRING_ERROR | associated error messages |
| 22012 | DIVISION_BY_ZERO | associated error messages |
| 22015 | INTERVAL_FIELD_OVERFLOW | associated error messages |
| 22018 | INVALID_CHARACTER_VALUE_FOR_CAST | |
| 22019 | INVALID_ESCAPE_CHARACTER | associated error messages |
| 2201B | INVALID_REGULAR_EXPRESSION | associated error messages |
| 2201E | INVALID_ARGUMENT_FOR_LOG | |
| 2201F | INVALID_ARGUMENT_FOR_POWER_FUNCTION | |
| 2201G | INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION | associated error messages |
| 22020 | INVALID_LIMIT_VALUE | |
| 22021 | CHARACTER_NOT_IN_REPERTOIRE | associated error messages |
| 22022 | INDICATOR_OVERFLOW | |
| 22023 | INVALID_PARAMETER_VALUE | associated error messages |
| 22024 | UNTERMINATED_C_STRING | |
| 22025 | INVALID_ESCAPE_SEQUENCE | associated error messages |
| 22026 | STRING_DATA_LENGTH_MISMATCH | |
| 22027 | TRIM_ERROR | |
| 2202E | ARRAY_ELEMENT_ERROR | |
| 22906 | NONSTANDARD_USE_OF_ESCAPE_CHARACTER | associated error messages |
| 22V01 | FLOATING_POINT_EXCEPTION | |
| 22V02 | INVALID_TEXT_REPRESENTATION | associated error messages |
| 22V03 | INVALID_BINARY_REPRESENTATION | associated error messages |
| 22V04 | BAD_COPY_FILE_FORMAT | associated error messages |
| 22V05 | UNTRANSLATABLE_CHARACTER | |
| 22V0B | ESCAPE_CHARACTER_ON_NOESCAPE | associated error messages |
| 22V21 | INVALID_EPOCH | associated error messages |
| 22V23 | RAISE_EXCEPTION | associated error messages |
| 22V24 | COPY_PARSE_ERROR | associated error messages |
| Class 23—Integrity Constraint Violation | ||
| 23000 | INTEGRITY_CONSTRAINT_VIOLATION | |
| 23001 | RESTRICT_VIOLATION | |
| 23502 | NOT_NULL_VIOLATION | associated error messages |
| 23503 | FOREIGN_KEY_VIOLATION | associated error messages |
| 23505 | UNIQUE_VIOLATION | associated error messages |
| 23514 | CHECK_VIOLATION | associated error messages |
| Class 24—Invalid Cursor State | ||
| 24000 | INVALID_CURSOR_STATE | |
| Class 25—Invalid Transaction State | ||
| 25000 | INVALID_TRANSACTION_STATE | associated error messages |
| 25001 | ACTIVE_SQL_TRANSACTION | |
| 25002 | BRANCH_TRANSACTION_ALREADY_ACTIVE | |
| 25003 | INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION | |
| 25004 | INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION | |
| 25005 | NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION | |
| 25006 | READ_ONLY_SQL_TRANSACTION | associated error messages |
| 25007 | SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED | |
| 25008 | HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL | |
| 25V01 | NO_ACTIVE_SQL_TRANSACTION | associated error messages |
| 25V02 | IN_FAILED_SQL_TRANSACTION | |
| Class 26—Invalid SQL Statement Name | ||
| 26000 | INVALID_SQL_STATEMENT_NAME | |
| Class 27—Triggered Data Change Violation | ||
| 27000 | TRIGGERED_DATA_CHANGE_VIOLATION | |
| Class 28—Invalid Authorization Specification | ||
| 28000 | INVALID_AUTHORIZATION_SPECIFICATION | associated error messages |
| 28001 | ACCOUNT_LOCKED | associated error messages |
| 28002 | PASSWORD_EXPIRED | |
| 28003 | PASSWORD_IN_GRACE_PERIOD | |
| Class 2B—Dependent Privilege Descriptors Still Exist | ||
| 2B000 | DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST | |
| 2BV01 | DEPENDENT_OBJECTS_STILL_EXIST | associated error messages |
| Class 2D—Invalid Transaction Termination | ||
| 2D000 | INVALID_TRANSACTION_TERMINATION | |
| Class 2F—SQL Routine Exception | ||
| 2F000 | SQL_ROUTINE_EXCEPTION | |
| 2F002 | S_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED | |
| 2F003 | S_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED | |
| 2F004 | S_R_E_READING_SQL_DATA_NOT_PERMITTED | |
| 2F005 | S_R_E_FUNCTION_EXECUTED_NO_RETURN_STATEMENT | |
| Class 34—Invalid Cursor Name | ||
| 34000 | INVALID_CURSOR_NAME | |
| Class 38—External Routine Exception | ||
| 38000 | EXTERNAL_ROUTINE_EXCEPTION | |
| 38001 | E_R_E_CONTAINING_SQL_NOT_PERMITTED | |
| 38002 | E_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED | |
| 38003 | E_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED | |
| 38004 | E_R_E_READING_SQL_DATA_NOT_PERMITTED | associated error messages |
| Class 39—External Routine Invocation Exception | ||
| 39000 | EXTERNAL_ROUTINE_INVOCATION_EXCEPTION | |
| 39001 | E_R_I_E_INVALID_SQLSTATE_RETURNED | |
| 39004 | E_R_I_E_NULL_VALUE_NOT_ALLOWED | |
| 39V01 | E_R_I_E_TRIGGER_PROTOCOL_VIOLATED | |
| 39V02 | E_R_I_E_SRF_PROTOCOL_VIOLATED | |
| Class 3B—Savepoint Exception | ||
| 3B000 | SAVEPOINT_EXCEPTION | |
| 3B001 | S_E_INVALID_SPECIFICATION | |
| Class 3D—Invalid Catalog Name | ||
| 3D000 | INVALID_CATALOG_NAME | |
| Class 3F—Invalid Schema Name | ||
| 3F000 | INVALID_SCHEMA_NAME | |
| Class 40—Transaction Rollback | ||
| 40000 | TRANSACTION_ROLLBACK | |
| 40001 | T_R_SERIALIZATION_FAILURE | |
| 40002 | T_R_INTEGRITY_CONSTRAINT_VIOLATION | |
| 40003 | T_R_STATEMENT_COMPLETION_UNKNOWN | |
| 40V01 | T_R_DEADLOCK_DETECTED | associated error messages |
| Class 42—Syntax Error or Access Rule Violation | ||
| 42000 | SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION | |
| 42501 | INSUFFICIENT_PRIVILEGE | associated error messages |
| 42601 | SYNTAX_ERROR | associated error messages |
| 42602 | INVALID_NAME | associated error messages |
| 42611 | INVALID_COLUMN_DEFINITION | associated error messages |
| 42622 | NAME_TOO_LONG | associated error messages |
| 42701 | DUPLICATE_COLUMN | associated error messages |
| 42702 | AMBIGUOUS_COLUMN | associated error messages |
| 42703 | UNDEFINED_COLUMN | associated error messages |
| 42704 | UNDEFINED_OBJECT | associated error messages |
| 42710 | DUPLICATE_OBJECT | associated error messages |
| 42712 | DUPLICATE_ALIAS | associated error messages |
| 42723 | DUPLICATE_FUNCTION | associated error messages |
| 42725 | AMBIGUOUS_FUNCTION | associated error messages |
| 42803 | GROUPING_ERROR | associated error messages |
| 42804 | DATATYPE_MISMATCH | associated error messages |
| 42809 | WRONG_OBJECT_TYPE | associated error messages |
| 42830 | INVALID_FOREIGN_KEY | associated error messages |
| 42846 | CANNOT_COERCE | associated error messages |
| 42883 | UNDEFINED_FUNCTION | associated error messages |
| 42939 | RESERVED_NAME | associated error messages |
| 42P20 | WINDOWING_ERROR | associated error messages |
| 42V01 | UNDEFINED_TABLE | associated error messages |
| 42V02 | UNDEFINED_PARAMETER | associated error messages |
| 42V03 | DUPLICATE_CURSOR | associated error messages |
| 42V04 | DUPLICATE_DATABASE | associated error messages |
| 42V05 | DUPLICATE_PSTATEMENT | |
| 42V06 | DUPLICATE_SCHEMA | associated error messages |
| 42V07 | DUPLICATE_TABLE | associated error messages |
| 42V08 | AMBIGUOUS_PARAMETER | associated error messages |
| 42V09 | AMBIGUOUS_ALIAS | associated error messages |
| 42V10 | INVALID_COLUMN_REFERENCE | associated error messages |
| 42V11 | INVALID_CURSOR_DEFINITION | associated error messages |
| 42V12 | INVALID_DATABASE_DEFINITION | |
| 42V13 | INVALID_FUNCTION_DEFINITION | associated error messages |
| 42V14 | INVALID_PSTATEMENT_DEFINITION | |
| 42V15 | INVALID_SCHEMA_DEFINITION | associated error messages |
| 42V16 | INVALID_TABLE_DEFINITION | associated error messages |
| 42V17 | INVALID_OBJECT_DEFINITION | associated error messages |
| 42V18 | INDETERMINATE_DATATYPE | associated error messages |
| 42V21 | UNDEFINED_PROJECTION | associated error messages |
| 42V22 | UNDEFINED_NODE | associated error messages |
| 42V23 | UNDEFINED_PERMUTATION | |
| 42V24 | UNDEFINED_USER | associated error messages |
| 42V25 | PATTERN_MATCH_ERROR | associated error messages |
| 42V26 | DUPLICATE_NODE | associated error messages |
| Class 44—WITH CHECK OPTION Violation | ||
| 44000 | WITH_CHECK_OPTION_VIOLATION | |
| Class 53—Insufficient Resources | ||
| 53000 | INSUFFICIENT_RESOURCES | associated error messages |
| 53100 | DISK_FULL | associated error messages |
| 53200 | OUT_OF_MEMORY | associated error messages |
| 53300 | TOO_MANY_CONNECTIONS | |
| Class 54—Program Limit Exceeded | ||
| 54000 | PROGRAM_LIMIT_EXCEEDED | associated error messages |
| 54001 | STATEMENT_TOO_COMPLEX | associated error messages |
| 54011 | TOO_MANY_COLUMNS | associated error messages |
| 54023 | TOO_MANY_ARGUMENTS | associated error messages |
| Class 55—Object Not In Prerequisite State | ||
| 55000 | OBJECT_NOT_IN_PREREQUISITE_STATE | associated error messages |
| 55006 | OBJECT_IN_USE | associated error messages |
| 55V02 | CANT_CHANGE_RUNTIME_PARAM | associated error messages |
| 55V03 | LOCK_NOT_AVAILABLE | associated error messages |
| 55V04 | TM_MARKER_NOT_AVAILABLE | associated error messages |
| Class 57—Operator Intervention | ||
| 57000 | OPERATOR_INTERVENTION | |
| 57014 | QUERY_CANCELED | associated error messages |
| 57015 | SLOW_DELETE | associated error messages |
| 57V01 | ADMIN_SHUTDOWN | associated error messages |
| 57V02 | CRASH_SHUTDOWN | |
| 57V03 | CANNOT_CONNECT_NOW | associated error messages |
| 57V04 | DML_COMMIT_DURING_SHUTDOWN | associated error messages |
| Class 58—System Error | ||
| 58030 | IO_ERROR | associated error messages |
| 58V01 | UNDEFINED_FILE | associated error messages |
| 58V02 | DUPLICATE_FILE | |
| Class V0—PL/vSQL errors | ||
| V0001 | PLVSQL_ERROR | associated error messages |
| V0002 | PLVSQL_RAISE | |
| V0003 | NO_DATA_FOUND | |
| V0004 | TOO_MANY_ROWS | |
| V0005 | ASSERT_FAILURE | associated error messages |
| Class V1—Vertica-specific multi-node errors class | ||
| V1001 | LOST_CONNECTIVITY | associated error messages |
| V1002 | K_SAFETY_VIOLATION | associated error messages |
| V1003 | CLUSTER_CHANGE | associated error messages |
| Class V2—Vertica-specific miscellaneous errors class | ||
| V2000 | AUTH_FAILED | associated error messages |
| V2001 | LICENSE_ISSUE | associated error messages |
| V2002 | MOVEOUT_ABORTED | |
| Class VC—Configuration File Error | ||
| VC001 | CONFIG_FILE_ERROR | associated error messages |
| VC002 | LOCK_FILE_EXISTS | |
| Class VD—DB Designer errors | ||
| VD001 | DESIGNER_FUNCTION_ERROR | associated error messages |
| Class VP—User procedure errors | ||
| VP000 | USER_PROC_ERROR | associated error messages |
| VP001 | USER_PROC_EXEC_ERROR | associated error messages |
| Class VX—Internal Error | ||
| VX001 | INTERNAL_ERROR | associated error messages |
| VX002 | DATA_CORRUPTED | associated error messages |
| VX003 | INDEX_CORRUPTED | associated error messages |
| VX004 | PLAN_TO_SQL_INTERNAL_EROR | associated error messages |
| VX005 | INTERNAL_FILE_NOT_FOUND | |
In this section
- Messages associated with SQLSTATE 00000
- Messages associated with SQLSTATE 01000
- Messages associated with SQLSTATE 01004
- Messages associated with SQLSTATE 01006
- Messages associated with SQLSTATE 01007
- Messages associated with SQLSTATE 01009
- Messages associated with SQLSTATE 01V01
- Messages associated with SQLSTATE 02000
- Messages associated with SQLSTATE 08000
- Messages associated with SQLSTATE 08001
- Messages associated with SQLSTATE 08003
- Messages associated with SQLSTATE 08004
- Messages associated with SQLSTATE 08006
- Messages associated with SQLSTATE 08V01
- Messages associated with SQLSTATE 09000
- Messages associated with SQLSTATE 0A000
- Messages associated with SQLSTATE 0A005
- Messages associated with SQLSTATE 0B000
- Messages associated with SQLSTATE 0LV01
- Messages associated with SQLSTATE 20000
- Messages associated with SQLSTATE 21000
- Messages associated with SQLSTATE 22000
- Messages associated with SQLSTATE 22001
- Messages associated with SQLSTATE 22003
- Messages associated with SQLSTATE 22004
- Messages associated with SQLSTATE 22007
- Messages associated with SQLSTATE 22008
- Messages associated with SQLSTATE 22009
- Messages associated with SQLSTATE 2200B
- Messages associated with SQLSTATE 2200D
- Messages associated with SQLSTATE 22011
- Messages associated with SQLSTATE 22012
- Messages associated with SQLSTATE 22015
- Messages associated with SQLSTATE 22019
- Messages associated with SQLSTATE 2201B
- Messages associated with SQLSTATE 2201G
- Messages associated with SQLSTATE 22021
- Messages associated with SQLSTATE 22023
- Messages associated with SQLSTATE 22025
- Messages associated with SQLSTATE 22906
- Messages associated with SQLSTATE 22V02
- Messages associated with SQLSTATE 22V03
- Messages associated with SQLSTATE 22V04
- Messages associated with SQLSTATE 22V0B
- Messages associated with SQLSTATE 22V21
- Messages associated with SQLSTATE 22V23
- Messages associated with SQLSTATE 22V24
- Messages associated with SQLSTATE 23502
- Messages associated with SQLSTATE 23503
- Messages associated with SQLSTATE 23505
- Messages associated with SQLSTATE 23514
- Messages associated with SQLSTATE 25000
- Messages associated with SQLSTATE 25006
- Messages associated with SQLSTATE 25V01
- Messages associated with SQLSTATE 28000
- Messages associated with SQLSTATE 28001
- Messages associated with SQLSTATE 2BV01
- Messages associated with SQLSTATE 38004
- Messages associated with SQLSTATE 40V01
- Messages associated with SQLSTATE 42501
- Messages associated with SQLSTATE 42601
- Messages associated with SQLSTATE 42602
- Messages associated with SQLSTATE 42611
- Messages associated with SQLSTATE 42622
- Messages associated with SQLSTATE 42701
- Messages associated with SQLSTATE 42702
- Messages associated with SQLSTATE 42703
- Messages associated with SQLSTATE 42704
- Messages associated with SQLSTATE 42710
- Messages associated with SQLSTATE 42712
- Messages associated with SQLSTATE 42723
- Messages associated with SQLSTATE 42725
- Messages associated with SQLSTATE 42803
- Messages associated with SQLSTATE 42804
- Messages associated with SQLSTATE 42809
- Messages associated with SQLSTATE 42830
- Messages associated with SQLSTATE 42846
- Messages associated with SQLSTATE 42883
- Messages associated with SQLSTATE 42939
- Messages associated with SQLSTATE 42P20
- Messages associated with SQLSTATE 42V01
- Messages associated with SQLSTATE 42V02
- Messages associated with SQLSTATE 42V03
- Messages associated with SQLSTATE 42V04
- Messages associated with SQLSTATE 42V06
- Messages associated with SQLSTATE 42V07
- Messages associated with SQLSTATE 42V08
- Messages associated with SQLSTATE 42V09
- Messages associated with SQLSTATE 42V10
- Messages associated with SQLSTATE 42V11
- Messages associated with SQLSTATE 42V13
- Messages associated with SQLSTATE 42V15
- Messages associated with SQLSTATE 42V16
- Messages associated with SQLSTATE 42V17
- Messages associated with SQLSTATE 42V18
- Messages associated with SQLSTATE 42V21
- Messages associated with SQLSTATE 42V22
- Messages associated with SQLSTATE 42V24
- Messages associated with SQLSTATE 42V25
- Messages associated with SQLSTATE 42V26
- Messages associated with SQLSTATE 53000
- Messages associated with SQLSTATE 53100
- Messages associated with SQLSTATE 53200
- Messages associated with SQLSTATE 54000
- Messages associated with SQLSTATE 54001
- Messages associated with SQLSTATE 54011
- Messages associated with SQLSTATE 54023
- Messages associated with SQLSTATE 55000
- Messages associated with SQLSTATE 55006
- Messages associated with SQLSTATE 55V02
- Messages associated with SQLSTATE 55V03
- Messages associated with SQLSTATE 55V04
- Messages associated with SQLSTATE 57014
- Messages associated with SQLSTATE 57015
- Messages associated with SQLSTATE 57V01
- Messages associated with SQLSTATE 57V03
- Messages associated with SQLSTATE 57V04
- Messages associated with SQLSTATE 58030
- Messages associated with SQLSTATE 58V01
- Messages associated with SQLSTATE V0001
- Messages associated with SQLSTATE V0005
- Messages associated with SQLSTATE V1001
- Messages associated with SQLSTATE V1002
- Messages associated with SQLSTATE V1003
- Messages associated with SQLSTATE V2000
- Messages associated with SQLSTATE V2001
- Messages associated with SQLSTATE VC001
- Messages associated with SQLSTATE VD001
- Messages associated with SQLSTATE VP000
- Messages associated with SQLSTATE VP001
- Messages associated with SQLSTATE VX001
- Messages associated with SQLSTATE VX002
- Messages associated with SQLSTATE VX003
- Messages associated with SQLSTATE VX004