Query: drop_sequence
OS: suse
Section: 7
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
DROPSEQUENCE(7) SQL Commands 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)] SQL - Language Statements 2010-05-14 DROP SEQUENCE(7)
Related Man Pages |
---|
drop_aggregate(7) - suse |
drop_schema(7) - suse |
drop_table(7) - debian |
drop_table(7) - mojave |
drop_table(7) - linux |
Similar Topics in the Unix Linux Community |
---|
Oracle: adding numbering to a table... |
Need Help with AWK |
Need help with "awk" |