Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages

RedHat 9 (Linux i386) - man page for drop_type (redhat section 7)

DROP
TYPE(7) SQL Commands DROP TYPE(7)
NAME
DROP TYPE - remove a user-defined data type
SYNOPSIS
DROP TYPE typename [, ...] [ CASCADE | RESTRICT ] INPUTS typename The name (optionally schema-qualified) of an existing type. CASCADE Automatically drop objects that depend on the type (such as table columns, functions, operators, etc). RESTRICT Refuse to drop the type if there are any dependent objects. This is the default. OUTPUTS DROP TYPE The message returned if the command is successful. ERROR: RemoveType: type 'typename' does not exist This message occurs if the specified type is not found.
DESCRIPTION
DROP TYPE will remove a user type from the system catalogs. Only the owner of a type can remove it.
EXAMPLES
To remove the box type: DROP TYPE box;
COMPATIBILITY
Note that the CREATE TYPE command and the data type extension mechanisms in PostgreSQL differ from SQL99.
SEE ALSO
CREATE TYPE [create_type(7)] SQL - Language Statements 2002-11-22 DROP TYPE(7)


All times are GMT -4. The time now is 12:11 PM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
UNIX.COM Login
Username:
Password:  
Show Password