how to drop or delete the foregin key in sql table

USE mydb

GO

ALTER TABLE Emp DROP CONSTRAINT

GO

Hope you got your answer, kindly mark it as accepted @periyasamy p

You can do either using SQL Server Management Studio or executing query.

SQL server Management Studio:

1. In Object Explorer, expand the table with the constraint and then expand Keys.
2. Right-click the constraint and then click Delete.
3. In the Delete Object dialog box, click OK.

Query:

USE ;
GO
ALTER TABLE 
DROP CONSTRAINT ;
GO

Syntax:

ALTER TABLE 

DROP CONSTRAINT ;

Example

ALTER TABLE Student

DROP CONSTRAINT fk_student_city_id;

Hello Periyasamy,

Please refer this link which will help to understand from scrach how to add contraints and remove constraint,

https://www.w3schools.com/sql/sql_foreignkey.asp

In SQL, you can use the ALTER TABLE statement to drop a foreign key constraint from a table. The basic syntax is as follows:

ALTER TABLE table_name

DROP FOREIGN KEY constraint_name;

Please note that if you drop a foreign key constraint from a table, any data that is dependent on that constraint will also be deleted. So, you need to be careful when using this statement and make sure you have a backup of your data.

Two options

1. You can make it using a script 

ALTER TABLE Table
DROP CONSTRAINT ConstraintName;

2. Using Management Explorer, just select the column and remove the constraint.

You can delete FK as shown below.

Example:

ALTER TABLE 
DROP CONSTRAINT ;

For more details please refer below link.

https://learn.microsoft.com/en-us/sql/relational-databases/tables/delete-foreign-key-relationships?view=sql-server-ver16

https://stackoverflow.com/questions/1776079/sql-drop-table-foreign-key-constraint

Thanks.