From cae83f6d4fc3eef57814e6bd554bc39461644359 Mon Sep 17 00:00:00 2001 From: Michael Trier Date: Sun, 28 Dec 2008 07:40:56 +0000 Subject: On MSSQL if a field is part of the primary_key then it should not allow NULLS. --- lib/sqlalchemy/databases/mssql.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/sqlalchemy/databases') diff --git a/lib/sqlalchemy/databases/mssql.py b/lib/sqlalchemy/databases/mssql.py index 777c86d40..61f54a8ba 100644 --- a/lib/sqlalchemy/databases/mssql.py +++ b/lib/sqlalchemy/databases/mssql.py @@ -1499,7 +1499,7 @@ class MSSQLSchemaGenerator(compiler.SchemaGenerator): colspec = self.preparer.format_column(column) + " " + column.type.dialect_impl(self.dialect).get_col_spec() if column.nullable is not None: - if not column.nullable: + if not column.nullable or column.primary_key: colspec += " NOT NULL" else: colspec += " NULL" -- cgit v1.2.1