remove a subscription NAME DROP_SUBSCRIPTION - remove a subscription SYNOPSIS DROP SUBSCRIPTION [ IF EXISTS ] name [ CASCADE | RESTRIC......SQL extension. SEE ALSO ALTER SUBSCRIPTION ( ALTER_SUBSCRIPTION (7)), DROP SUBSCRIPTION ( DROP_SUBSCRIPTION (7)), CREATE PUBLICATION ( CREATE_PUBLICATION (7)), ALTER PUBLICATION…...slot from the subscription and drop the subscription as explained in DROP SUBSCRIPTION ( DROP_SUBSCRIPTION (7)). Commands ALTER SUBSCRIPTION ... REFRESH PUBLICATION , ALTER SUBS…change the definition of a publication NAME ALTER_PUBLICATION - change the definition of a publication SYNOPSIS ALTER PUBLICATION name ADD publication_object [, ...] ALTER PUBLICAT…define a new publication NAME CREATE_PUBLICATION - define a new publication SYNOPSIS CREATE PUBLICATION name [ FOR ALL TABLES | FOR publication_object [, ... ] ] [ WITH ( publicati…remove a database NAME DROP_DATABASE - remove a database SYNOPSIS DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ] where option can be: FORCE DESCRIPTION DROP DATAB…define or change a security label applied to an object NAME SECURITY_LABEL - define or change a security label applied to an object SYNOPSIS SECURITY LABEL [ FOR provider ] ON { TA…define or change the comment of an object NAME COMMENT - define or change the comment of an object SYNOPSIS COMMENT ON { ACCESS METHOD object_name | AGGREGATE aggregate_name ( aggr…remove a routine NAME DROP_ROUTINE - remove a routine SYNOPSIS DROP ROUTINE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ] DE…remove an operator class NAME DROP_OPERATOR_CLASS - remove an operator class SYNOPSIS DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] DESCRIPTION D…remove an index NAME DROP_INDEX - remove an index SYNOPSIS DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DESCRIPTION DROP INDEX drops an existing in…remove a function NAME DROP_FUNCTION - remove a function SYNOPSIS DROP FUNCTION [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT …remove a procedure NAME DROP_PROCEDURE - remove a procedure SYNOPSIS DROP PROCEDURE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTR…remove an operator family NAME DROP_OPERATOR_FAMILY - remove an operator family SYNOPSIS DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] DESCRIPTI…remove a procedural language NAME DROP_LANGUAGE - remove a procedural language SYNOPSIS DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ] DESCRIPTION DROP LANG…remove a rewrite rule NAME DROP_RULE - remove a rewrite rule SYNOPSIS DROP RULE [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ] DESCRIPTION DROP RULE drops a rewrite rule. …remove a collation NAME DROP_COLLATION - remove a collation SYNOPSIS DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ] DESCRIPTION DROP COLLATION removes a previously define…remove an access method NAME DROP_ACCESS_METHOD - remove an access method SYNOPSIS DROP ACCESS METHOD [ IF EXISTS ] name [ CASCADE | RESTRICT ] DESCRIPTION DROP ACCESS METHOD remov…remove a database role NAME DROP_GROUP - remove a database role SYNOPSIS DROP GROUP [ IF EXISTS ] name [, ...] DESCRIPTION DROP GROUP is now an alias for DROP ROLE . COMPATIBILITY …remove a database role NAME DROP_ROLE - remove a database role SYNOPSIS DROP ROLE [ IF EXISTS ] name [, ...] DESCRIPTION DROP ROLE removes the specified role(s). To drop a superuse…