add new column with default constraint in sql

ALTER TABLE Employee
 ADD IsDeleted bit NOT NULL
 CONSTRAINT   DF_Employee _IsDeleted  default 0