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

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.

• 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.