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(at)earthlink(dot)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
>
>
>
>