SHOW AVAILABLE LISTINGS¶

Lists the listings that are available to the user who runs the command. For more information, see Listing availability options.

See also:: CREATE LISTING, CREATE APPLICATION … FROM LISTING, ALTER LISTING, DESCRIBE LISTING, DROP LISTING,

Syntax¶

SHOW AVAILABLE LISTINGS

SHOW [ TERSE ] AVAILABLE LISTINGS
    [ LIMIT <rows> ]
    [ IS_IMPORTED = TRUE ]
    [ IS_ORGANIZATION = TRUE ]
    [ IS_SHARED_WITH_ME = TRUE ]

SHOW AVAILABLE LISTINGS [ LIKE <pattern> ]
  IN DATA EXCHANGE <name>;

Copy

Parameters¶

LIMIT rows

Optionally limits the maximum number of rows returned, while also enabling “pagination” of the results. The actual number of rows returned might be less than the specified limit. For example, the number of existing objects is less than the specified limit.

TERSE

Optionally returns output containing only the following columns:

created_on
global_name
profile
title

IS_SHARED_WITH_ME = TRUE

Optional, shows only listings shared privately with the current user.

Property value

Behavior

Not set

All listings are returned.

TRUE

Only listings shared privately with the current user are returned.

IS_IMPORTED = TRUE

Optional, shows only imported listings, but filters returned results according to:

Property value	Behavior
Not set	All listings are returned.
TRUE	Only imported listings are returned.

IS_ORGANIZATION = TRUE

Optional, shows only organization level listings.

Property value	Behavior
Not set	All listings are returned.
TRUE	Shows organization level listings.

LIKE 'pattern'

Optionally filters the command output by object name. The filter uses case-insensitive pattern matching, with support for SQL wildcard characters (% and _).

For example, the following patterns return the same results:

... LIKE '%testing%' ...

... LIKE '%TESTING%' ...

. Default: No value (no filtering is applied to the output).

IN DATA EXCHANGE name: The name of the Data Exchange where the available listings are located.

Usage notes¶

Only one of filters IS_IMPORTED, IS_ORGANIZATION, or IS_SHARED_WITH_ME may be specified at a time.