From d918eb8ce8c7e20b8451187d4660c0ee22e81d39 Mon Sep 17 00:00:00 2001 From: Rick Morrison Date: Thu, 26 Jul 2007 17:05:11 +0000 Subject: [PATCH] mssql: indexes are now quoted when dropping from reflected tables [ticket:684] --- CHANGES | 1 + lib/sqlalchemy/databases/mssql.py | 4 +++- 2 files changed, 4 insertions(+), 1 deletion(-) diff --git a/CHANGES b/CHANGES index c0575f5ccb..c4dcf46762 100644 --- a/CHANGES +++ b/CHANGES @@ -21,6 +21,7 @@ - mssql - added support for TIME columns (simulated using DATETIME) [ticket:679] + - index names are now quoted when dropping from reflected tables [ticket:684] 0.3.9 - general diff --git a/lib/sqlalchemy/databases/mssql.py b/lib/sqlalchemy/databases/mssql.py index 81536aab1b..ba1c0fd9d6 100644 --- a/lib/sqlalchemy/databases/mssql.py +++ b/lib/sqlalchemy/databases/mssql.py @@ -915,7 +915,9 @@ class MSSQLSchemaGenerator(ansisql.ANSISchemaGenerator): class MSSQLSchemaDropper(ansisql.ANSISchemaDropper): def visit_index(self, index): - self.append("\nDROP INDEX " + index.table.name + "." + index.name) + self.append("\nDROP INDEX %s.%s" % ( + self.preparer.quote_identifier(index.table.name), + self.preparer.quote_identifier(index.name))) self.execute() class MSSQLDefaultRunner(ansisql.ANSIDefaultRunner): -- 2.47.2