Can we use SELECT statement in CHECK constraint statement in Create Table statment as follows : CHECK(DeptID IN (Select DeptID from Department)) ?

In the above statement we are trying to check the DeptID column value must be exist in DeptID column of Department table. but we can not use SELECT statement in CHECK constraint, if we use SELECT statement in CHECK constraint SQLServer will give error msg: "Subqueries are not allowed in this context. Only scalar expressions are allowed." So we can not use SELECT statement in CHECK Constraint statement.