LIST TOPICS

Syntax

{ LIST | SHOW } TOPICS [IN STORE store_name];

Description

This command provides a list of Topics in a Store. By default, the current session Store will be used.

Topics will only be listed if the current role has USAGE privileges on the Store.

Arguments

IN STORE store_name

Optionally, this lists the Topics in the specified Store.

Examples

List Topics in the current Store

The following lists the Topics in the current Store.

demodb.public/demostore# LIST TOPICS;
  Topic name
--------------
  pageviews

List Topics in a specified Store

The following lists the Topics in the Store otherstore.

demodb.public/demostore# LIST TOPICS IN STORE otherstore;
  Topic name
--------------
  users