With the DROP SERIAL statement, you can drop a serial object from the database.
DROP SERIAL serial_identifier
The following example shows how to drop the order_no serial.
DROP SERIAL order_no;