How can we find the table definition is a synapse dedicated SQL pool.

Singh, Shiv Bhole 6 Reputation points
2022-07-15T06:12:00.837+00:00

I required the definition of all tables in my synapse dedicated SQL pool I tried to look into the sys metadata tables but did not find a solution. Please help me here if there is any possible way is there to get the definitions of the available tables.

Azure Database Migration service
Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,358 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
493 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,886 Reputation points MVP
    2022-07-15T06:20:23.357+00:00

    Below link should help :
    learn.microsoft.com/en-us/sql/relational-databases/tables/view-the-table-definition?view=sql-server-ver16

  2. LiHong-MSFT 10,046 Reputation points
    2022-07-18T03:20:59.123+00:00

    Hi @Singh, Shiv Bhole
    If you want to script the entire database, you can right-click on the database name and select Generate scripts which starts the script wizard.
    221596-image.png
    Then select all the tables or specify the tables you want.
    221648-image.png
    Save the scripts to a file or a new query window.
    221679-image.png

    Best regards,
    LiHong

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.