sp_drop_openrowset_statistics (Transact-SQL)
Applies to: 
Azure SQL Managed Instance
Azure Synapse Analytics (serverless SQL pool only)
Drops column statistics for a column in the OPENROWSET path of Azure Synapse serverless SQL pools. For more information, see Statistics in Synapse SQL. This procedure is also used by Azure SQL Managed Instance for column statistics in external data sources via OPENROWSET.
There is no direct method to update existing statistics. Instead, drop and create statistics using sp_create_openrowset_statistics.
Transact-SQL Syntax Conventions
Syntax
sys.sp_drop_openrowset_statistics [ @stmt = ] N'statement_text'
Arguments
[ @stmt = ] N'statement_text'
Specifies a Transact-SQL statement that will return column values to be used for statistics. You can use TABLESAMPLE within the @stmt to specify samples of data to be used. If TABLESAMPLE isn't specified, FULLSCAN will be used.
<tablesample_clause> ::= TABLESAMPLE ( sample_number PERCENT )
Remarks
Statistics metadata is not available for OPENROWSET columns.
Permissions
Requires ADMINISTER BULK OPERATIONS or ADMINISTER DATABASE BULK OPERATIONS permissions.
Example
For usage scenarios and examples, review Update statistics.