如何在MS SQL中的现有（填充）表中添加NOT NULL FOREIGN KEY列？

I need to add a NOT NULL column to an existing (populated) table that will be a foreign key to another table. This brings about two problems:I need to add a NOT NULL column to an existing