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@earthlink.net> wrote in message
Id> news:3Qv56.2577$Ps.115717@newsread2.prod.itd.earthlink.net...
>> 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
>>
>>
>>
