Events
Sep 15, 6 AM - Sep 17, 3 PM
The best SQL community-led learning event. Sept 2025. Save €200 with code FABLEARN.
Get registeredNote
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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's no direct method to update existing statistics. Instead, drop and create statistics using sp_create_openrowset_statistics.
Transact-SQL syntax conventions
sys.sp_drop_openrowset_statistics
[ @stmt = ] N'stmt'
Important
Arguments for extended stored procedures must be entered in the specific order as described in the Syntax section. If the parameters are entered out of order, an error message occurs.
Specifies a Transact-SQL statement that returns column values to be used for statistics. You can use TABLESAMPLE within @stmt to specify samples of data to be used. If TABLESAMPLE isn't specified, FULLSCAN is used.
<tablesample_clause> ::= TABLESAMPLE ( sample_number PERCENT )
Statistics metadata isn't available for OPENROWSET columns.
Requires ADMINISTER BULK OPERATIONS or ADMINISTER DATABASE BULK OPERATIONS permissions.
For usage scenarios and examples, review Update statistics.