Free Webmaster Tools and Resources

W3-Tools.com

Articles

Search Engine Optimization Domain Names Webmasters Web design

Webmaster Forum Webmaster News Links Directory

SEO Tools

Search Engine Spider Simulator Keyword Analyser Tool Keywords Generator

Domain Tools

Domain Name Checker Whois Domain Lookup Domain Typo Generator

Web Utilities

HTTP Header Viewer Link Extractor Mime Types List

HTML Tools

Websafe Color Tool HTML Entity Chart

Documentation

PHP Manual PEAR Manual Smarty Manual PHP-GTK Manual Apache Manual MySQL Manual PostgreSQL Manual

PostgreSQL Manual

This manual is provided as a courtesy. It is not an official source. Please check postgresql.org for updated information.

PostgreSQL Manual

PostgreSQL 8.1.3 Documentation
Prev	Fast Backward		Fast Forward	Next

DROP SEQUENCE

Name

DROP SEQUENCE -- remove a sequence

Synopsis

DROP SEQUENCE name [, ...] [ CASCADE | RESTRICT ]

Description

DROP SEQUENCE removes sequence number generators.

Parameters

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.

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.

Newsletter

Join to our newsletter and receive news and updates about our site.
Your name:
E-mail address:
Action:

Hosted by

Search

			Links