Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help 
DROP SEQUENCE(7)	  PostgreSQL 18.4 Documentation 	DROP SEQUENCE(7)

NAME
     DROP_SEQUENCE - remove a sequence

SYNOPSIS
     DROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

DESCRIPTION
     DROP  SEQUENCE  removes  sequence number generators. A sequence can only be
     dropped by its owner or a superuser.

PARAMETERS
     IF EXISTS
	 Do not throw an error if the sequence does not exist. A notice  is  is-
	 sued in this case.

     name
	 The name (optionally schema-qualified) of a sequence.

     CASCADE
	 Automatically drop objects that depend on the sequence, and in turn all
	 objects that depend on those objects (see Section 5.15).

     RESTRICT
	 Refuse  to  drop  the sequence if any objects depend on it. This is the
	 default.

EXAMPLES
     To remove the sequence serial:

	 DROP SEQUENCE serial;

COMPATIBILITY
     DROP SEQUENCE conforms to the SQL standard, except that the  standard  only
     allows one sequence to be dropped per command, and apart from the IF EXISTS
     option, which is a PostgreSQL extension.

SEE ALSO
     CREATE SEQUENCE (CREATE_SEQUENCE(7)), ALTER SEQUENCE (ALTER_SEQUENCE(7))

PostgreSQL 18.4 		      2026			DROP SEQUENCE(7)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=DROP_SEQUENCE&sektion=7&manpath=FreeBSD+Ports+15.1.quarterly>

home | help