Delete and foreign key constraint SQL
<p>I have a project table has a primary key "projectID", each project has tasks then in my task table that has a primary key "taskID", I have the foreign key "ProjetID".</p>

<p>I want to know if it is possible that if I delete a project, the tasks carried out in this project remains in the task table and will not be removed.</p>