‘OPTIMIZE_FOR_SEQUENTIAL_KEY‘ is not a recognized CREATE TABLE option.

￡神魔★判官ぃ 2023-09-29 14:14 2阅读 0赞

**代码报错：**

**'OPTIMIZE\_FOR\_SEQUENTIAL\_KEY' is not a recognized CREATE TABLE option.**

**报错部分代码：**

WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON，OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF）

![120444e4f8fd4ef18f9a3848f8b609ff.png][]

**报错原因：**

您的目标 SQL Server 只是一个旧版本。 OPTIMIZE\_FOR\_SEQUENTIAL\_KEY 是 SQL Server 2019 中的一项新功能。

**解决方案：**

可以简单地删除该选项。如果您没有将任何选项设置为非默认值，您可以删除所有这些选项。或者查看您的主机是否有可用的 SQL Server 2019。

即：**直接将 OPTIMIZE\_FOR\_SEQUENTIAL\_KEY = OFF 删除**。

**原版解答：**

> Your target SQL Server is simply an older version. It's SQL Server 2014 SP3 CU4 to be exact, and OPTIMIZE\_FOR\_SEQUENTIAL\_KEY is a new feature in SQL Server 2019. SSMS scripting always recites all the options, even when set to the default value to ensure full fidelity scripting, which sometimes a pain.  
> You can simply remove that option and the script should be compatible with SQL 2014. In fact you can remove all those options if you haven't set any to a non-default value.  
> Or see if your hoster has SQL Server 2019 available. Or upgrade your hoster.

[ssms - Would removing 'OPTIMIZE\_FOR\_SEQUENTIAL\_KEY' solve the failure of my script.sql or is more involved (SQL Server Express DB -> SQL Server)? - Stack Overflow![favicon.ico_v_ec617d715196][]https://stackoverflow.com/questions/64503483/would-removing-optimize-for-sequential-key-solve-the-failure-of-my-script-sql][ssms - Would removing _OPTIMIZE_FOR_SEQUENTIAL_KEY_ solve the failure of my script.sql or is more involved _SQL Server Express DB -_ SQL Server_ - Stack Overflow_favicon.ico_v_ec617d715196_https_stackoverflow.com_questions_64503483_would-removing-optimize-for-sequential-key-solve-the-failure-of-my-script-sql]

[120444e4f8fd4ef18f9a3848f8b609ff.png]: https://img-blog.csdnimg.cn/120444e4f8fd4ef18f9a3848f8b609ff.png
[favicon.ico_v_ec617d715196]: https://cdn.sstatic.net/Sites/stackoverflow/Img/favicon.ico?v=ec617d715196
[ssms - Would removing _OPTIMIZE_FOR_SEQUENTIAL_KEY_ solve the failure of my script.sql or is more involved _SQL Server Express DB -_ SQL Server_ - Stack Overflow_favicon.ico_v_ec617d715196_https_stackoverflow.com_questions_64503483_would-removing-optimize-for-sequential-key-solve-the-failure-of-my-script-sql]: https://stackoverflow.com/questions/64503483/would-removing-optimize-for-sequential-key-solve-the-failure-of-my-script-sql