Updating bool to non-nullable in sql server

Question

I'm looking for the equivalent of the query below for bit data types

 Sql("ALTER TABLE Table_name ALTER COLUMN column INTEGER NOT NULL");

Thanks

There is no equivalent, because SQL Server does not have a boolean data type. — Gordon Linoff, Nov 13 '18 at 16:28
this might be helpful https://stackoverflow.com/questions/1777257/how-do-you-create-a-yes-no-boolean-field-in-sql-server — user4321, Nov 13 '18 at 16:37
BIT columns *can* be null-able though if you allow them to be... but this isn't good practice. — S3S, Nov 13 '18 at 16:40

score 0 · Accepted Answer · answered Nov 13 '18 at 16:35

0

You probably mean:

Sql("ALTER TABLE Table_name ALTER COLUMN column BIT NOT NULL");

answered Nov 13 '18 at 16:35

user1443098

1 Answers1