var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: drop all sequences
How do i drop all sequences in a schema in db2? Dropping it one by one is very difficult as there are huge number of sequences.
db2 -x "select 'drop sequence '||SEQSCHEMA||'.'||SEQNAME||';' from syscat.sequences where seqschema = 'schemaname' " > drop_seq.sql
this will create script for you on drop_seq.sql after this
db2 -tvf drop_seq.sql -z drop_seq.out
will drop all the seq on tht schema
You may want to use RTRIM() around the schema name, otherwise you'll end up with a statement like this:
Originally Posted by Mathew_paul
drop sequence MYSCHEMA .MYNAME...
Thanks for your reply