From bb5ef32b2536e0184090d56432cc75f8c6757845 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Edgar=20Ram=C3=ADrez=20Mondrag=C3=B3n?= Date: Thu, 18 Dec 2025 13:33:25 -0600 Subject: [PATCH] Do not check server version and refactor into f-string MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Edgar Ramírez Mondragón --- lib/sqlalchemy/dialects/mssql/base.py | 20 ++++++-------------- 1 file changed, 6 insertions(+), 14 deletions(-) diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py index 256f975fde..3f501bc1f4 100644 --- a/lib/sqlalchemy/dialects/mssql/base.py +++ b/lib/sqlalchemy/dialects/mssql/base.py @@ -2691,20 +2691,12 @@ class MSDDLCompiler(compiler.DDLCompiler): return text def visit_drop_index(self, drop: DropIndex, **kw: Any) -> str: - index = drop.element - - text = "\nDROP INDEX " - - if ( - # only supported in 2016+ - self.dialect.server_version_info < MS_2016_VERSION - and drop.if_exists - ): - text += "IF EXISTS " - - text += self._prepared_index_name(index, include_schema=False) - text += " ON " + self.preparer.format_table(index.table) - return text + index_name = self._prepared_index_name( + drop.element, include_schema=False + ) + table_name = self.preparer.format_table(drop.element.table) + if_exists = " IF EXISTS" if drop.if_exists else "" + return f"\nDROP INDEX {index_name}{if_exists} ON {table_name}" def visit_create_table_as(self, element, **kw): prep = self.preparer -- 2.47.3