sql2005数据库增添外键级联删除外键对应的主键行

sql2005数据库添加外键级联删除外键对应的主键行
alter TABLE  Asp_News
with check add
constraint foreignKey_News_UserID
Foreign Key
(UserID)
References Asp_Members(ID)
On Delete Cascade
Not For Replication
GO