Query: drop_sequence
OS: centos
Section: 7
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
DROPSEQUENCE(7) PostgreSQL 9.2.7 Documentation DROP SEQUENCE(7)NAMEDROP_SEQUENCE - remove a sequenceSYNOPSISDROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DESCRIPTIONDROP SEQUENCE removes sequence number generators. A sequence can only be dropped by its owner or a superuser.PARAMETERSIF EXISTS Do not throw an error if the sequence does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of a sequence. CASCADE Automatically drop objects that depend on the sequence. RESTRICT Refuse to drop the sequence if any objects depend on it. This is the default.EXAMPLESTo remove the sequence serial: DROP SEQUENCE serial;COMPATIBILITYDROP 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 ALSOCREATE SEQUENCE (CREATE_SEQUENCE(7)), ALTER SEQUENCE (ALTER_SEQUENCE(7)) PostgreSQL 9.2.7 2014-02-17 DROP SEQUENCE(7)
Related Man Pages |
---|
drop_extension(7) - centos |
drop_foreign_table(7) - centos |
drop_schema(7) - centos |
drop_table(7) - debian |
drop_table(7) - mojave |
Similar Topics in the Unix Linux Community |
---|
Oracle: adding numbering to a table... |
Need Help with AWK |
Need help with "awk" |