在sqlserver2008中删除一个列，永久拥有foreignkey [英] drop a column in sqlserver2008,permanently having foreignkey

问题描述

我想在具有foreignkeyreferenced的表中删除一列，请帮助我

i want to drop a column in a table which has foreignkeyreferenced,pls help me

推荐答案

首先删除外键： -

First drop foreign key:-

alter table table_name drop foreignkey_Name

然后删除列

then drop column

alter table table_name drop column Column_Name

试试这个...... :)

try this...:)

ALTER TABLE Orders
DROP CONSTRAINT fk_PerOrders

如何在SQL Server中删除外键？ [ ^ ]



SQL Server外键更新和删除规则 [ ^ ]



查看链接..希望它会有所帮助..

How do I drop a foreign key in SQL Server?[^]

SQL Server Foreign Key Update and Delete Rules[^]

Check the links..hope it will help..

这篇关于在sqlserver2008中删除一个列，永久拥有foreignkey的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！