By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

How to delete sequences

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
DROP SEQUENCE <seqname> RESTRICT
Nov 12 '05 #2

P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.