Teradata Database Message 4320 - 4320 - Analytics Database - Teradata Vantage

Message

Schema may not be dropped because it is associated with one or more columns.

Explanation

Generated when an attempting to drop a schema via the DROP SCHEMA statement and it is still in use by some column.

Generated By

PAR modules

For Whom

End User

Notes

None

Remedy

use the DBC.SchemaDependenciesV dictionary view to find all columns currently using the schema that needs to be dropped