Fast & Scalable Analytics Pipelines with MotherDuck & dltHubRegister for the live event

Skip to main content

LIST SHARES

The LIST SHARES statement is used to list all shares that you've created. You can also use the table function md_list_database_shares().

tip

Looking for all the shares that you have access to? Take a look at the md_information_schema.

Syntax

-- using DDL
LIST SHARES;
-- using table function
SELECT name, url, source_db_name FROM md_list_database_shares();