Dump table and view DDL from Azure SQL Data Warehouse

Question

How does one dump/export the DDL at the schema-level on Microsoft's Azure SQL Data Warehouse?

Answer 1

Are you still experiencing this issue? Please make sure you have selected the correct database engine type and edition within SSMS to generate scripts.

Follow these instructions:

Use SSMS (Right Click on database name/Generate Scripts/Next/select “Select specific database objects”/Click on Tables and Views/Click Next/Click on Advanced/Scroll down and look for “Script for the database engine type/Select “Microsoft Azure SQL Database”/

For option “Script for the database engine edition”/Select “Microsoft Azure SQL Data Warehouse”/OK/Change location and file name then select Next/Next