drop_aggregate man page on UnixWare

Man page or keyword search:  
man Server   3616 pages
apropos Keyword Search (all sections)
Output format
UnixWare logo
[printable version]

DROP AGGREGATE()		 SQL Commands		      DROP AGGREGATE()

NAME
       DROP AGGREGATE - remove an aggregate function

SYNOPSIS
       DROP AGGREGATE [ IF EXISTS ] name ( type [ , ... ] ) [ CASCADE | RESTRICT ]

DESCRIPTION
       DROP  AGGREGATE	will delete an existing aggregate function. To execute
       this command the current user must be the owner of the aggregate	 func‐
       tion.

PARAMETERS
       IF EXISTS
	      Do  not throw an error if the aggregate does not exist. A notice
	      is issued in this case.

       name   The name (optionally schema-qualified) of an existing  aggregate
	      function.

       type   An input data type on which the aggregate function operates.  To
	      reference a zero-argument aggregate function, write *  in	 place
	      of the list of input data types.

       CASCADE
	      Automatically  drop  objects  that depend on the aggregate func‐
	      tion.

       RESTRICT
	      Refuse to drop the aggregate function if any objects  depend  on
	      it. This is the default.

EXAMPLES
       To remove the aggregate function myavg for type integer:

       DROP AGGREGATE myavg(integer);

COMPATIBILITY
       There is no DROP AGGREGATE statement in the SQL standard.

SEE ALSO
       ALTER  AGGREGATE	 [alter_aggregate(5)], CREATE AGGREGATE [create_aggre‐
       gate(l)]

SQL - Language Statements	  2008-01-03		      DROP AGGREGATE()
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server UnixWare

List of man pages available for UnixWare

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net