I’m recently started working in Microsoft Synapse and exploring the templates with tables and need to retrieve a list of all tables from a specific schema in the templates e.g. Automotive. I’ve tried using the DESCRIBE command, but it only gives information about a single table. How can I write a SQL query to list all tables in a schema and export it to CSV? 

Is there a specific system view or query I should use in Synapse to achieve this?

Any help would be appreciated.

Thanks in advance!

​I’m recently started working in Microsoft Synapse and exploring the templates with tables and need to retrieve a list of all tables from a specific schema in the templates e.g. Automotive. I’ve tried using the DESCRIBE command, but it only gives information about a single table. How can I write a SQL query to list all tables in a schema and export it to CSV?  Is there a specific system view or query I should use in Synapse to achieve this? Any help would be appreciated.Thanks in advance!  Read More

​