Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 26 of 30
To drop the specification and body of an object, a varray, or nested table type. To drop just the body of an object type, see "DROP TYPE BODY".
The object, varray, or nested table type must be in your own schema or you must have the DROP
ANY
TYPE
system privilege.
schema |
is the schema containing the type. If you omit schema, Oracle assumes the type is in your own schema. |
type_name |
is the name of the object, varray, or nested table type to be dropped. You can drop only types with no type or table dependencies.
If type_name is a statistics type, this statement will fail unless you also specify See Also: "ASSOCIATE STATISTICS" and "DISASSOCIATE STATISTICS" for more information on statistics types. |
|
If type_name is an object type that has been associated with a statistics type, Oracle first attempts to disassociate type_name from the statistics type and then drop type_name. However, if statistics have been collected using the statistics type, Oracle will be unable to disassociate type_name from the statistics type, and this statement will fail. |
|
If type_name is an implementation type for an indextype, the indextype will be marked
Unless you specify See Also: "CREATE INDEXTYPE". |
|
forces the type to be dropped even if it has dependent database objects. Oracle marks |
|
WARNING: Oracle does not recommend that you specify |
The following statement removes object type PERSON_T
:
DROP TYPE person_t;
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|