KFAA30695-E

An SQL statement was executed with RESTRICT specified for the drop behavior, but the SQL statement resulted in an error for one of the following reasons. <SQLSTATE: 42I44>

1. An attempt was made to delete base tables for which indexes or constraints were defined.

2. An attempt was made to delete schemas for which tables were defined.

3. An attempt was made to delete a table on which viewed tables depend.

4. An attempt was made to delete columns for which indexes or constraints were defined.

5. An attempt was made to delete a column of a table on which viewed tables depend.

6. An attempt was made to delete a foreign server used in a foreign table.

7. An attempt was made to delete a foreign table on which viewed tables depend.

Note

Because range indexes are always defined for archivable multi-chunk tables, deleting an archivable multi-chunk table results in error for reason 1 above.

aa....aa: SQL statement that caused the error

• table: DROP TABLE statement

• schema: DROP SCHEMA statement

• viewed table: DROP VIEW statement

• column of table: Deleting a column by ALTER TABLE statement

• foreign server: DROP SERVER statement

• foreign table: DROP FOREIGN TABLE statement

bb....bb: Defined object

• table: Table

• index: Index

• viewed table: Viewed table

• constraint: Constraint

• foreign table: A foreign table

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Identify the object that caused the error from the following table. Make sure that no problems occur if tables, indexes, or constraints are deleted (or viewed tables are deleted or invalidated) during execution of the SQL statement output in aa....aa. If there are no problems, re-execute the SQL statement with CASCADE specified for the drop behavior or without specifying the drop behavior.

Information output to aa....aa	Information output to bb....bb	Error cause object
table	index	The indexes defined in the table to be deleted (including the range indexes defined in the archive range column of the archivable multi-chunk table)
	constraint	Constraint defined in the table to be deleted
	viewed table	Viewed table that uses the table to be deleted as its underlying table or that depends on the table to be deleted
schema	table	Tables, viewed tables, and indexes defined in the schema to be deleted
viewed table	viewed table	Viewed table that uses the viewed table to be deleted as its underlying table or that depends on the viewed table to be deleted
column of table	index	Index defined in the column to be deleted
	constraint	Constraint defined in the column to be deleted
	viewed table	Viewed table dependent on the table deleting columns
foreign server	foreign table	Foreign table using a foreign server to be deleted
foreign table	viewed table	Viewed table dependent on the foreign table to be deleted