Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

does dropping table drop sequence too?

642301May 30 2008 — edited May 30 2008
In oracle 9,10, pl/sql, does dropping a table also drop all associated sequences (the columns that increment with nextval)?

I created the table and the sequence separately and I use an 'insert into' statement to add values to a column in the table.

I don't think there is a permanent connection between the column and the sequence but I'm wondering if it is possible anyway.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2008
Added on May 30 2008
3 comments
1,089 views