how to drop or delete the foregin key in sql table

Question

To drop or delete the foregin key in sql table in microsoft sql management

Rijwan Ansari · Answer

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

Vishal Yelve · Answer

Syntax: ALTER TABLE DROP CONSTRAINT ; Example ALTER TABLE Student DROP CONSTRAINT fk_student_city_id;

Jignesh Kumar · Answer

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

Anupam Maiti · Answer

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.

Aravind Govindaraj · Answer

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.

Naimish Makwana · Answer

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.

Rajeev Kumar · Answer

USE mydb GO ALTER TABLE Emp DROP CONSTRAINT GO

Aradhana Tripathi · Answer

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

how to drop or delete the foregin key in sql table

Answers (8)