| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_drop_openrowset_statistics (Transact-SQL) |
The sp_drop_openrowset_statistics system stored procedure removes column statistics for a column in the OPENROWSET path of Azure Synapse SQL resources. |
WilliamDAssafMSFT |
wiassaf |
randolphwest |
03/07/2025 |
azure-synapse-analytics |
reference |
|
|
|
=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.