SQL Server Error Code – 13766 cannot drop the clustered index ‘%.*ls’

In this blog post, you’ll learn more about the SQL Server Error Code 13766 and the error message description that is shown

SQL Server Error Code

13766

SQL Server Error Description for the Code :13766

Cannot drop the clustered index ‘%.*ls’ because it is being used for automatic cleanup of aged data. Consider setting HISTORY_RETENTION_PERIOD to INFINITE on the corresponding system-versioned temporal table if you need to drop this index.