Re: DROP SEQUENCE ?

Are you using the right name for the sequence>  I am very new to sql
so I might be off base here but the name of the sequence is:

<tablename>_<serialdatatypename>_id_seq

sql snippet

DROP TABLE members;
DROP
DROP SEQUENCE members_member_id_seq;
DROP

CREATE TABLE members (
    member_id           serial,
    member_type       VARCHAR(10),
    username            VARCHAR(20),
    password            VARCHAR(20),
    prefix                 VARCHAR(10),
    name_first          VARCHAR(20),
    name_last           VARCHAR(20),
    name_suffix         VARCHAR(10),
    address_street1    VAR CHAR(25),
    address_street2    VAR CHAR(25),
    address_city        VARCHAR(20),
    address_state      VARCHAR(2),
    address_zip         VARCHAR(10),
    phone                 VARCHAR(13),
    email                  VARCHAR(30),
    timedate_creation   TIMESTAMP,
    timedate_mod        TIMESTAMP,
    rating                   INTEGER,
    preferences         VARCHAR(100),
    account_bal         NUMERIC(16,2)
    );
NOTICE:  CREATE TABLE will create implicit sequence
'members_member_id_seq' for SERIAL column 'members.member_id'
NOTICE:  CREATE TABLE/UNIQUE will create implicit index
'members_member_id_key' for table 'members'
CREATE

imago


----- Original Message -----
From: "Ian deSouza" <iandesouza@earthlink.net>
To: <>
Sent: Friday, January 05, 2001 9:57 PM
Subject: [GENERAL] DROP SEQUENCE ?


> Anybody know the syntax of the DROP SEQUENCE sql statement for
PostgreSQL?
>
> Once I create a table with an attribute of type SERIAL, and drop
the table,
> I cannot recreate the table since the sequence already exists (and
DROP
> TABLE tableName does not remove the sequence entry). Does anybody
know what
> I would have to do to follow the DROP TABLE w/ to remove the
"sequence"
> created by the SERIAL datatype?
>
> Thanks in advance, Ian
>
>
>
>