Add mssql_include option for mssql dialect

1 files changed, 10 insertions, 0 deletions

diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py
index aacc58ba8..29f32f3f1 100644
--- a/lib/sqlalchemy/dialects/mssql/base.py
+++ b/lib/sqlalchemy/dialects/mssql/base.py
@@ -957,6 +957,16 @@ class MSDDLCompiler(compiler.DDLCompiler):
                         preparer.format_table(index.table),
                         ', '.join([preparer.quote(c.name, c.quote) + (" " + o if o else "")
                                    for c, o in zip(index.columns, ordering)]))
+
+        # handle other included columns
+        if index.kwargs.get("mssql_include"):
+            inclusions = [index.table.c[col] if isinstance(col, basestring) else col
+                          for col in index.kwargs["mssql_include"]]
+
+            text += " INCLUDE (%s)" \
+                % ', '.join([preparer.quote(c.name, c.quote)
+                             for c in inclusions])
+
         return text
 
     def visit_drop_index(self, drop):