Kbase 15139: How to drop an Oracle Table/INDEX and Sequence
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/09/1998 |
|
How to drop an Oracle Table/INDEX and Sequence
A table can be dropped by using the drop table command. When specifyi
ng this command the cascade constraint option can be used in order to
remove alll referential integrity constraints referring to the dropped
table. In addition an index and a sequence can be dropped by using t
he drop index or drop sequence commands.
Unanswered issues:`
1. When dropping a table, are all indexes and sequences associated wi
th the table automatically dropped.
2. Must any indexes and/or sequences associated with a table be dropp
ed prior to dropping the table..
3. for a related table, index, and sequence, what is the correct orde
r for dropping these objects from the database.
Progress Software Technical Support Note # 15139