DROP SEQUENCE
  SQL - Language Statements
 
 
  DROP SEQUENCE
  remove a sequence
 
 
  DROP SEQUENCE
 
 
DROP SEQUENCE name [, ...] [ CASCADE | RESTRICT ]
 
 
  Description
  
   DROP SEQUENCE removes sequence number generators.
  
 
  
 
  Parameters
  
   
    name
    
     
      The name (optionally schema-qualified) of a sequence.
     
    
   
   
    CASCADE
    
     
      Automatically drop objects that depend on the sequence.
     
    
   
   
    RESTRICT
    
     
      Refuse to drop the sequence if any objects depend on it.  This
      is the default.
     
    
   
  
 
 
  Examples
  
   To remove the sequence serial:
DROP SEQUENCE serial;
  
 
 
 
  Compatibility
  
   There is no DROP SEQUENCE statement in the SQL standard.
  
 
 
  See Also