(1) Resources that are deleted when a schema is deleted
When a schema is deleted, the schema owner's resources are also deleted. This means that the following resources are deleted:
Tables
Indexes
View tables
Comments
Access privileges
Abstract data types
Index type
Stored procedures
Stored functions
Trigger
Foreign table
Foreign index
(2) Other users' resources that are affected
View tables are deleted
Because the schema owner's tables and view tables are deleted, all view tables created from any of those tables or view tables are also deleted.
Access privileges are revoked
Because the schema owner's tables and view tables are deleted, all access privileges for those tables and view tables are revoked.
Stored routines and triggers become invalid
Because the schema owner's tables, view tables, indexes, abstract data types, stored routines, and triggers are deleted, stored routines and triggers that use any of these resources become invalid.
(3) When a schema cannot be deleted
Your schema cannot be deleted if a user is accessing an abstract data type that is defined in a table you own.
The schema of a user who owns a falsification prevented table that contains data cannot be deleted.