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

Accepted 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

Muhammad Ahsan6y ago

this error is occuring when I'm doing this

Harsh Shah6y ago

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 Gohil6y ago

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;

Amit Gupta6y ago

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