How to delete sequences

Jan Suchanek

Hello,

I am writing a script to help me migarte von database to another. It
should create all tables, indexes and sequences automaticly. While
developing I have to test the script from time to time. So i have to
delete the created objects sometimes. No problem with tables and
indexes, but how can I delete sequences?

Thanks.

Greetings, Jan

Nov 12 '05 #1

Serge Rielau

DROP SEQUENCE <seqname> RESTRICT

Nov 12 '05 #2

Jan Suchanek

Serge Rielau wrote:

DROP SEQUENCE <seqname> RESTRICT

Yepp... thanks... just as I found out by myself... but I promise to try
harder before I ask next time ;-)

Greetings, Jan

Nov 12 '05 #3

richardshen

drop sequence [name]
Jan Suchanek <ja**********@gmx.de> wrote in message news:<41******@news.uni-ulm.de>...

Hello,

I am writing a script to help me migarte von database to another. It
should create all tables, indexes and sequences automaticly. While
developing I have to test the script from time to time. So i have to
delete the created objects sometimes. No problem with tables and
indexes, but how can I delete sequences?

Thanks.

Greetings, Jan

Nov 12 '05 #4