The sp_drop_create_stats_external_table is able to generate all the T-SQL statements for drop and create statistics defined on SQL Server external tables in your database! The CREATE STATISTICS ...

Generate statements from your Production tables and then run those statements in your Dev/Test environments. Schedule this as part of a SQL Job to keep all of your environments in-sync. Enter test ...

To understand how to choose the best distribution method and use distributed tables, see designing distributed tables using dedicated SQL pool in Azure Synapse Analytics.. For recommendations on the ...