SELECT
OBJECT_NAME(fk.constraint_object_id) AS ConstraintName,
fk.constraint_column_id AS ColumnId,
col.name AS ColumnName
FROM
sys.foreign_key_columns fk
INNER JOIN
sys.columns col ON fk.parent_object_id = col.object_id AND fk.parent_column_id = col.column_id
WHERE
OBJECT_NAME(fk.parent_object_id) = 'Orders';
Ya CONSTRAINT folder me ja k CONSTRAINT key copy paste kare
ALTER TABLE Tbl_Name
DROP CONSTRAINT [ForeignKeyConstraintName]; -- Yahan [ForeignKeyConstraintName] ko actual constraint naam se replace karein
How to remove Foreign Key Constraint in SQL
Reviewed by Rikesh
on
December 03, 2024
Rating:
![How to remove Foreign Key Constraint in SQL](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisBMrSM3jGQecpRODY4NEu3HG5QXt7YU75Y1mCkkVexmIvsq6PleQHnIc5xdAZtObMa3ldJTnKBUw4KXPVBDTt7d25WQ72GMga5P6-_NxOobaMyPTqxE3_WznKGIx4QBXGIkJGxbXSvw8Ab0XoTWDF-AA6d9bNjxt80Jsq3hq8xnN9efRDgJY4njhyphenhyphenPICs/s72-c/How%20to%20remove%20Foreign%20Key%20Constraint%20in%20SQL.png)
No comments: