How do you create a yes/no boolean field in SQL server?

akantro_4653 0
Viewed 1015473

What is the best practice for creating a yes/no i.e. Boolean field when converting from an access database or in general?

sqldatatypes boolean sql-server
12 Answers

In SQL Server Management Studio of Any Version, Use BIT as Data Type

which will provide you with True or False Value options. in case you want to use Only 1 or 0 then you can use this method: 

CREATE TABLE SampleBit(
    bar int NOT NULL CONSTRAINT CK_foo_bar CHECK (bar IN (-1, 0, 1))
)

But I will strictly advise BIT as The BEST Option. Hope fully it's help someone.

user_90572420

If you are using Postgres, the BIT type won't support it. So, you have to use INT for storing boolean type. In that case, you can assume 0 as false and 1 as true.

[ColumnName]  INT NULL  DEFAULT 0
user_71038820
Related