SHOW SUBSCRIPTION

Go Up to Statement and Function Reference (Language Reference Guide)

Syntax

SHOW {SUBSCRIPTION [<subscription_name>] | SUBSCRIPTIONS};

Argument	Description
<subscription_name>	The name of the subscription that you want to display.

Description

To display a list of all subscriptions, use the SHOW SUPSCRIPTIONS command. If you only want to display one supscription, use the SHOW SUPSCRIPTION <subscription_name> command.

Example

SHOW SUBSCRIPTIONS;
Subscription Name
===================================================================
SUB_CUSTOMER_DELETES
SUB_EMPLOYEE_CHANGES
SUB_VARIOUS_CHANGES
 
SHOW SUBSCRIPTION sub_employee_changes;
Subscription name: SUB_EMPLOYEE_CHANGES
Owner: SYSDBA
Description: Subscribe to changes in EMPLOYEE table
        EMPLOYEE (SALARY, DEPT_NO, EMP_NO)
 
SHOW SUBSCRIPTION sub_customer_deletes;
Subscription name: SUB_CUSTOMER_DELETES
Owner: SYSDBA
Description: Subscribe to deletes in CUSTOMER table
        CUSTOMER FOR ROW (DELETE)
 
SHOW SUBSCRIPTION sub_various_changes;
Subscription name: SUB_VARIOUS_CHANGES
Owner: SYSDBA
Description: Subscribe to various changes on multiple tables
        EMPLOYEE FOR ROW (INSERT, UPDATE, DELETE),
        CUSTOMER FOR ROW (INSERT, UPDATE, DELETE),
        SALES FOR ROW (UPDATE),
        DEPARTMENT (LOCATION) FOR ROW (UPDATE)

See Also

• GRANT
• REVOKE
• CREATE SUBSCRIPTION
• DROP SUBSCRIPTION
• SET SUBSCRIPTION
• GRANT SUBSCRIBE
• GRANT TEMPORARY SUBSCRIBE
• Data Definition Guide

Advance To:

• Procedures and Triggers