"Cannot drop last unique index of an immediate materialized view"
| Item |
Description |
|
SQLCode
|
-1184L
|
|
Constant
|
DELETE_UPDATABLE_MATVIEW_INDEX_ERR
|
|
SQLState
|
55W21
|
|
ODBC 2 State
|
42000
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
2861
|
|
Severity Code
|
16
|
Probable cause
You attempted to drop the last unique index on non-nullable columns of an immediate materialized view. Immediate materialized view needs at least one unique index on non-nullable columns in order to be valid.