Re[2]: DROP SEQUENCE ?

DROP SEQUENCE EMPLOYEE_ID_seq;
And it is in the docs..

Id> The PostgreSQL doc referencing this situation is at
Id> http://www.postgresql.org/devel-corner/docs/user/datatype.htm#AEN1181
Id> but it doesn't explain what the syntax is nor does it give an example.
Id> So if Employee has an attribute called ID that is of type SERIAL, and we do
Id> a
Id> "DROP TABLE EMPLOYEE"
Id> what kind of call should we issue to drop the sequence?
Id> DROP SEQUENCE ...??

Id> "Ian deSouza" <iandesouza(at)earthlink(dot)net> wrote in message
Id> news:3Qv56(dot)2577$Ps(dot)115717(at)newsread2(dot)prod(dot)itd(dot)earthlink(dot)net(dot)(dot)(dot)
>> 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
Id> table,
>> I cannot recreate the table since the sequence already exists (and DROP
>> TABLE tableName does not remove the sequence entry). Does anybody know
Id> 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
>>
>>
>>