mssql provide boolean value default create table code example Example: add bool column in sql ALTER TABLE person add [AdminApproved] BIT default 'FALSE';