Re: using "sequence", how to drop constraints?

matthew taylor wrote:
>

                [ big snip ]
>
> // now cleanup ie. drop sequence and table.
> drop SEQUENCE s_customer_id;
> DROP TABLE s_customer;
> // note - do not need to drop constraints in addition to dropping table.
> // but how to drop constraint without dropping table (and data)??

        Try ALTER TABLE s_customer_id DROP CONSTRAINT <constraint_name>;

-- 
Jerry Gitomer
Once I learned how to spell DBA, I became one.