Issue Type: Bug In SQL Server 2019 BDC create an External table using data source SqlDataPool: ... Unable to Script out External Table from ADS/SSMS if DATA_SOURCE = SqlDataPool #7506. Copy link.

####In this script, replace 'MY_SERVER_NAME' with your server name and 'MY_DATABASE_NAME' with your database name. This script will generate a SQL script for each table in the specified database and ...

Another nice feature of the Table Designer is the “Generate Change Script” button. If you have made changes, then the exact T-SQL code that is required to make those changes is generated.