首页 > 其他 > 详细

解决外键无法删除问题

时间:2017-04-26 12:46:04      阅读:233      评论:0      收藏:0      [点我收藏+]

SELECT  fk.name ,
        fk.object_id ,
        OBJECT_NAME(fk.parent_object_id) AS referenceTableName
FROM    sys.foreign_keys AS fk
        JOIN sys.objects AS o ON fk.referenced_object_id = o.object_id
WHERE   o.name = ‘AppTag‘;

SELECT
    ‘ALTER TABLE ‘ +  OBJECT_SCHEMA_NAME(parent_object_id) +
    ‘.[‘ + OBJECT_NAME(parent_object_id) +
    ‘] DROP CONSTRAINT ‘ + name
FROM sys.foreign_keys
WHERE referenced_object_id = object_id(‘AppInfo‘)


SELECT * 
FROM sys.foreign_keys
WHERE referenced_object_id = object_id(‘Student‘)



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

解决外键无法删除问题

原文:http://www.cnblogs.com/kevin1988/p/6767824.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!