DROP PUBLICATION¶
Function¶
Deletes a publication.
Precautions¶
This statement is supported by clusters of version 8.2.0.100 or later.
This statement can be used by the publication owner and system administrators only.
Syntax¶
DROP PUBLICATION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
Parameter Description¶
IF EXISTS
If the specified publication does not exist, no error is thrown. Instead, a notification is reported indicating that the publication does not exist.
name
Specifies the name of the publication you want to delete.
Value range: an existing publication
CASCADE | RESTRICT
Currently, these keywords do not work because there is no dependency on publications.
Examples¶
Delete a publication.
DROP PUBLICATION mypublication;