DROP LANGUAGE
  SQL - Language Statements
 
 
  
   DROP LANGUAGE
  
  
   remove a user-defined procedural language
  
 
 
  
   1999-07-20
  
  
DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]
  
  
  
   
    1998-04-15
   
   
    Inputs
   
   
    
     
      name
      
       
	The name of an existing procedural language.  For backward
        compatibility, the name may be enclosed by single quotes.
       
      
     
     
      CASCADE
      
       
        Automatically drop objects that depend on the language
	(such as functions in the language).
       
      
     
     
      RESTRICT
      
       
        Refuse to drop the language if there are any dependent objects.
	This is the default.
       
      
     
    
   
  
  
  
   
    1998-04-15
   
   
    Outputs
   
   
    
     
      
DROP LANGUAGE
       
      
       
	This message is returned if the language is successfully dropped.
       
      
     
     
      
ERROR: Language "name" doesn't exist
       
      
       
	This message occurs if a language called
	name is
	not found in the database.
       
      
     
    
   
  
 
 
 
  
   1998-04-15
  
  
   Description
  
  
   DROP PROCEDURAL LANGUAGE will remove the definition
   of the previously registered procedural language called
   name.
  
  
  
   
    1998-04-15
   
   
    Notes
   
   
    The DROP PROCEDURAL LANGUAGE statement is
    a PostgreSQL language extension.
   
   
    Refer to
    
    for information on how to create procedural languages.
   
  
 
 
 
  
   Usage
  
  
   This command removes the PL/Sample language:
   
DROP LANGUAGE plsample;
   
  
 
 
 
  
   Compatibility
  
  
  
   
    1998-04-15
   
   
    SQL92
   
   
    There is no DROP PROCEDURAL LANGUAGE in 
    SQL92.