diff options
| author | Rick Morrison <rickmorrison@gmail.com> | 2007-07-26 17:05:11 +0000 |
|---|---|---|
| committer | Rick Morrison <rickmorrison@gmail.com> | 2007-07-26 17:05:11 +0000 |
| commit | d918eb8ce8c7e20b8451187d4660c0ee22e81d39 (patch) | |
| tree | ec6c04414bd20e6c4e68eea9554cb3a24e00040c | |
| parent | 1c66e351324b89fc5570215d89ab04ed903c155b (diff) | |
| download | sqlalchemy-d918eb8ce8c7e20b8451187d4660c0ee22e81d39.tar.gz | |
mssql: indexes are now quoted when dropping from reflected tables [ticket:684]
| -rw-r--r-- | CHANGES | 1 | ||||
| -rw-r--r-- | lib/sqlalchemy/databases/mssql.py | 4 |
2 files changed, 4 insertions, 1 deletions
@@ -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 81536aab1..ba1c0fd9d 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): |