Hi,
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.

try this

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



regds
paul

You may want to use RTRIM() around the schema name, otherwise you'll end up with a statement like this:

Thanks for your reply