Na}{

File Content: `DROP_COLLATION.7`

'\" t
.\"     Title: DROP COLLATION
.\"    Author: The PostgreSQL Global Development Group
.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
.\"      Date: 2017-11-06
.\"    Manual: PostgreSQL 9.2.24 Documentation
.\"    Source: PostgreSQL 9.2.24
.\"  Language: English
.\"
.TH "DROP COLLATION" "7" "2017-11-06" "PostgreSQL 9.2.24" "PostgreSQL 9.2.24 Documentation"
.\" -----------------------------------------------------------------
.\" * Define some portability stuff
.\" -----------------------------------------------------------------
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.\" http://bugs.debian.org/507673
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\" -----------------------------------------------------------------
.\" * set default formatting
.\" -----------------------------------------------------------------
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
.\" -----------------------------------------------------------------
.\" * MAIN CONTENT STARTS HERE *
.\" -----------------------------------------------------------------
.SH "NAME"
DROP_COLLATION \- remove a collation
.\" DROP COLLATION
.SH "SYNOPSIS"
.sp
.nf
DROP COLLATION [ IF EXISTS ] \fIname\fR [ CASCADE | RESTRICT ]
.fi
.SH "DESCRIPTION"
.PP
\fBDROP COLLATION\fR
removes a previously defined collation\&. To be able to drop a collation, you must own the collation\&.
.SH "PARAMETERS"
.PP
IF EXISTS
.RS 4
Do not throw an error if the collation does not exist\&. A notice is issued in this case\&.
.RE
.PP
\fIname\fR
.RS 4
The name of the collation\&. The collation name can be schema\-qualified\&.
.RE
.PP
CASCADE
.RS 4
Automatically drop objects that depend on the collation\&.
.RE
.PP
RESTRICT
.RS 4
Refuse to drop the collation if any objects depend on it\&. This is the default\&.
.RE
.SH "EXAMPLES"
.PP
To drop the collation named
german:
.sp
.if n \{\
.RS 4
.\}
.nf
DROP COLLATION german;
.fi
.if n \{\
.RE
.\}
.SH "COMPATIBILITY"
.PP
The
\fBDROP COLLATION\fR
command conforms to the
SQL
standard, apart from the
IF EXISTS
option, which is a
PostgreSQL
extension\&.
.SH "SEE ALSO"
ALTER COLLATION (\fBALTER_COLLATION\fR(7)), CREATE COLLATION (\fBCREATE_COLLATION\fR(7))

Name	Size	Permission
ABORT.7	2249 bytes	0644
ALTER_AGGREGATE.7	3614 bytes	0644
ALTER_COLLATION.7	2867 bytes	0644
ALTER_CONVERSION.7	2965 bytes	0644
ALTER_DATABASE.7	5407 bytes	0644
ALTER_DEFAULT_PRIVILEGES.7	6541 bytes	0644
ALTER_DOMAIN.7	6948 bytes	0644
ALTER_EXTENSION.7	6702 bytes	0644
ALTER_FOREIGN_DATA_WRAPPER.7	4478 bytes	0644
ALTER_FOREIGN_TABLE.7	7784 bytes	0644
ALTER_FUNCTION.7	7806 bytes	0644
ALTER_GROUP.7	3077 bytes	0644
ALTER_INDEX.7	4622 bytes	0644
ALTER_LANGUAGE.7	2148 bytes	0644
ALTER_LARGE_OBJECT.7	2020 bytes	0644
ALTER_OPERATOR.7	3082 bytes	0644
ALTER_OPERATOR_CLASS.7	2917 bytes	0644
ALTER_OPERATOR_FAMILY.7	9304 bytes	0644
ALTER_ROLE.7	8430 bytes	0644
ALTER_SCHEMA.7	2368 bytes	0644
ALTER_SEQUENCE.7	7700 bytes	0644
ALTER_SERVER.7	3486 bytes	0644
ALTER_TABLE.7	31239 bytes	0644
ALTER_TABLESPACE.7	3349 bytes	0644
ALTER_TEXT_SEARCH_CONFIGURATION.7	4919 bytes	0644
ALTER_TEXT_SEARCH_DICTIONARY.7	4131 bytes	0644
ALTER_TEXT_SEARCH_PARSER.7	2325 bytes	0644
ALTER_TEXT_SEARCH_TEMPLATE.7	2363 bytes	0644
ALTER_TRIGGER.7	2566 bytes	0644
ALTER_TYPE.7	7034 bytes	0644
ALTER_USER.7	2554 bytes	0644
ALTER_USER_MAPPING.7	3362 bytes	0644
ALTER_VIEW.7	3987 bytes	0644
ANALYZE.7	7699 bytes	0644
BEGIN.7	4181 bytes	0644
CHECKPOINT.7	2373 bytes	0644
CLOSE.7	2825 bytes	0644
CLUSTER.7	6411 bytes	0644
COMMENT.7	9213 bytes	0644
COMMIT.7	2173 bytes	0644
COMMIT_PREPARED.7	2676 bytes	0644
COPY.7	26747 bytes	0644
CREATE_AGGREGATE.7	9670 bytes	0644
CREATE_CAST.7	14405 bytes	0644
CREATE_COLLATION.7	4102 bytes	0644
CREATE_CONVERSION.7	3913 bytes	0644
CREATE_DATABASE.7	8045 bytes	0644
CREATE_DOMAIN.7	5501 bytes	0644
CREATE_EXTENSION.7	5810 bytes	0644
CREATE_FOREIGN_DATA_WRAPPER.7	5204 bytes	0644
CREATE_FOREIGN_TABLE.7	4817 bytes	0644
CREATE_FUNCTION.7	22138 bytes	0644
CREATE_GROUP.7	2222 bytes	0644
CREATE_INDEX.7	19167 bytes	0644
CREATE_LANGUAGE.7	10097 bytes	0644
CREATE_OPERATOR.7	7085 bytes	0644
CREATE_OPERATOR_CLASS.7	8746 bytes	0644
CREATE_OPERATOR_FAMILY.7	3726 bytes	0644
CREATE_ROLE.7	12472 bytes	0644
CREATE_RULE.7	8101 bytes	0644
CREATE_SCHEMA.7	5533 bytes	0644
CREATE_SEQUENCE.7	9324 bytes	0644
CREATE_SERVER.7	3770 bytes	0644
CREATE_TABLE.7	40782 bytes	0644
CREATE_TABLESPACE.7	3602 bytes	0644
CREATE_TABLE_AS.7	8133 bytes	0644
CREATE_TEXT_SEARCH_CONFIGURATION.7	3323 bytes	0644
CREATE_TEXT_SEARCH_DICTIONARY.7	3473 bytes	0644
CREATE_TEXT_SEARCH_PARSER.7	3696 bytes	0644
CREATE_TEXT_SEARCH_TEMPLATE.7	3512 bytes	0644
CREATE_TRIGGER.7	15472 bytes	0644
CREATE_TYPE.7	29012 bytes	0644
CREATE_USER.7	2539 bytes	0644
CREATE_USER_MAPPING.7	3386 bytes	0644
CREATE_VIEW.7	7305 bytes	0644
DEALLOCATE.7	2096 bytes	0644
DECLARE.7	10503 bytes	0644
DELETE.7	7563 bytes	0644
DISCARD.7	2588 bytes	0644
DO.7	3200 bytes	0644
DROP_AGGREGATE.7	2639 bytes	0644
DROP_CAST.7	2340 bytes	0644
DROP_COLLATION.7	2393 bytes	0644
DROP_CONVERSION.7	2454 bytes	0644
DROP_DATABASE.7	2466 bytes	0644
DROP_DOMAIN.7	2302 bytes	0644
DROP_EXTENSION.7	2704 bytes	0644
DROP_FOREIGN_DATA_WRAPPER.7	2576 bytes	0644
DROP_FOREIGN_TABLE.7	2564 bytes	0644
DROP_FUNCTION.7	3344 bytes	0644
DROP_GROUP.7	1638 bytes	0644
DROP_INDEX.7	3063 bytes	0644
DROP_LANGUAGE.7	2835 bytes	0644
DROP_OPERATOR.7	2968 bytes	0644
DROP_OPERATOR_CLASS.7	3459 bytes	0644
DROP_OPERATOR_FAMILY.7	3234 bytes	0644
DROP_OWNED.7	3089 bytes	0644
DROP_ROLE.7	3155 bytes	0644
DROP_RULE.7	2248 bytes	0644
DROP_SCHEMA.7	2611 bytes	0644
DROP_SEQUENCE.7	2432 bytes	0644
DROP_SERVER.7	2352 bytes	0644
DROP_TABLE.7	2944 bytes	0644
DROP_TABLESPACE.7	2574 bytes	0644
DROP_TEXT_SEARCH_CONFIGURATION.7	2830 bytes	0644
DROP_TEXT_SEARCH_DICTIONARY.7	2739 bytes	0644
DROP_TEXT_SEARCH_PARSER.7	2639 bytes	0644
DROP_TEXT_SEARCH_TEMPLATE.7	2677 bytes	0644
DROP_TRIGGER.7	2576 bytes	0644
DROP_TYPE.7	2490 bytes	0644
DROP_USER.7	1717 bytes	0644
DROP_USER_MAPPING.7	2656 bytes	0644
DROP_VIEW.7	2394 bytes	0644
END.7	2264 bytes	0644
EXECUTE.7	3034 bytes	0644
EXPLAIN.7	13204 bytes	0644
FETCH.7	8724 bytes	0644
GRANT.7	21922 bytes	0644
INSERT.7	8950 bytes	0644
LISTEN.7	3619 bytes	0644
LOAD.7	2644 bytes	0644
LOCK.7	8111 bytes	0644
MOVE.7	3034 bytes	0644
NOTIFY.7	8153 bytes	0644
PREPARE.7	6352 bytes	0644
PREPARE_TRANSACTION.7	5913 bytes	0644
REASSIGN_OWNED.7	3158 bytes	0644
REINDEX.7	8041 bytes	0644
RELEASE_SAVEPOINT.7	3138 bytes	0644
RESET.7	3027 bytes	0644
REVOKE.7	10714 bytes	0644
ROLLBACK.7	2172 bytes	0644
ROLLBACK_PREPARED.7	2701 bytes	0644
ROLLBACK_TO_SAVEPOINT.7	4102 bytes	0644
SAVEPOINT.7	3639 bytes	0644
SECURITY_LABEL.7	5420 bytes	0644
SELECT.7	54038 bytes	0644
SELECT_INTO.7	4634 bytes	0644
SET.7	7642 bytes	0644
SET_CONSTRAINTS.7	4668 bytes	0644
SET_ROLE.7	4483 bytes	0644
SET_SESSION_AUTHORIZATION.7	4013 bytes	0644
SET_TRANSACTION.7	8645 bytes	0644
SHOW.7	4347 bytes	0644
START_TRANSACTION.7	3004 bytes	0644
TABLE.7	18 bytes	0644
TRUNCATE.7	6394 bytes	0644
UNLISTEN.7	2841 bytes	0644
UPDATE.7	10887 bytes	0644
VACUUM.7	7264 bytes	0644
VALUES.7	7138 bytes	0644
WITH.7	18 bytes	0644

File Content: DROP_COLLATION.7

File Content: `DROP_COLLATION.7`