DROP SEQUENCE
  
  SQL - Language Statements
 
 
  
   DROP SEQUENCE
  
  
   Removes an existing sequence
  
 
  
   1998-09-22
  
  
DROP SEQUENCE seqname [, ...]
  
  
  
   
    1998-09-22
   
   
    Inputs
   
   
   
       
	
	 
	  seqname
	 
	 
	  
          The name of a sequence.
	  
	 
	
       
  
  
  
   
    1998-09-22
   
   
    Outputs
   
   
   
   
    
     
status
     
     
      
       
	
	 
	  DROP
	 
	 
	  
          The message returned if the sequence is successfully dropped.
	  
	 
	
	
	 
	  WARN: Relation "seqname" does not exist.
	 
	 
	  
	   This message occurs if the specified sequence does not exist.
	  
	 
	
       
     
    
   
  
 
 
 
  
   1998-09-22
  
  
   Description
  
  
   DROP SEQUENCE removes sequence number generators from the
   data base. With the current implementation of sequences as
   special tables it works just like the DROP TABLE
   statement.
  
  
  
   
    1998-09-22
   
   
    Notes
   
   
    The DROP SEQUENCE statement is a
 Postgres
    language extension.
   
   
    Refer to the CREATE SEQUENCE statement for
    information on how to create a sequence.
   
  
  
 
  
   Usage
  
  
   To remove sequence serial from database:
  
  
DROP SEQUENCE serial
  
 
 
 
  
   Compatibility
  
  
  
  
  
   
    1998-09-22
   
   
    SQL92
   
   
    There is no DROP SEQUENCE in SQL92.