I am using Northwind database and I am trying to delete the Products information from the Products table using SQL. However, when I tried to do that, it says that it can not be deleted because it is related to an another table. My problem is, when I deleted the table that was related to Products manually, it worked, but when I tried it code-wise, it is not working. How do I delete the relationship between the two tables because I just want to remove the information in the Products table? Can anyone help me on that?
Thanks in advance!