| title | sp_drop_openrowset_statistics (Transact-SQL) | ||
|---|---|---|---|
| description | The sp_drop_openrowset_statistics system stored procedure removes column statistics for a column in the OPENROWSET path of Azure Synapse SQL resources. | ||
| author | WilliamDAssafMSFT | ||
| ms.author | wiassaf | ||
| ms.reviewer | randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | azure-synapse-analytics | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
||
| monikerRange | =azure-sqldw-latest || =azuresqldb-mi-current |
[!INCLUDE asdbmi-asa-svrless-poolonly]
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 [!INCLUDE ssazuremi-md] 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.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sys.sp_drop_openrowset_statistics
[ @stmt = ] N'stmt'
[!INCLUDE extended-stored-procedures]
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.