How can i delete my Primary Key data from SQL Server?

Question

Hello i need your help i want to delete SQL server table data which contains Student data record table in which Student ID is a Primary key and i want to delete my selected row data from the sql server just like Mr Khan data this is useless for me but i don't want to drop my Primary Key so can you please guide me how can i solved this problem?

Jignesh Kumar · Answer

Hi, You need to delete your reference data from child table and then from main table. It seems you have reference data in you child table so it wan't allow to delete in main table. Delete from childTable where id=1 delete from maintable where id=1

Amit Gupta · Answer

No need to drop the pk, you cann call your query like delete from TableName where studentID ='Id to delete'

Muhammad Ahsan · Answer

this error is occuring when I'm doing this

Harsh Shah · Answer

Hii Muhammad Ahsan, delete from table_name where StudentId = id This query would not delete your primary key it just delete your row where studentid = id. Try this!!

Ajay Gohil · Answer

Hi, You can simply delete record without droping primary key.you can use delete statement with where condition and using that you can delete record.In where condition you can use name or you can use Id. Example delete from table_name where studentId=Id;

How can i delete my Primary Key data from SQL Server?

Answers (5)