DROP SEQUENCE
  
  SQL - Language Statements
 
 
  
   DROP SEQUENCE
  
  
   Removes existing sequences from a database
  
 
 
  
   1999-07-20
  
  
DROP SEQUENCE name [, ...]
  
  
  
   
    1998-09-22
   
   
    Inputs
   
   
    
     
      name
      
       
	The name of a sequence.
       
      
     
    
   
  
  
   
    1998-09-22
   
   
    Outputs
   
   
    
     
      
DROP
       
      
       
	The message returned if the sequence is successfully dropped.
       
      
     
     
      
ERROR: sequence "name" 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.