Which command will delete a sequence?
A) ALTER SEQUENCE...DELETE
B) ALTER SEQUENCE...DROP
C) DELETE SEQUENCE sequencename
D) DROP SEQUENCE sequencename

Question

Which command will delete a sequence?​
A) ​ALTER SEQUENCE...DELETE
B) ​ALTER SEQUENCE...DROP
C) ​DELETE SEQUENCE sequencename
D) ​DROP SEQUENCE sequencename

Quizplus · Accepted Answer

The correct syntax to delete a sequence in PostgreSQL is using the DROP SEQUENCE command followed by the name of the sequence. Therefore, the best choice is D. The other options (A, B, and C) are not valid in PostgreSQL.

Which Command Will Delete a Sequence?​

Which Command Will Delete a Sequence?