blocks|key|1400900|text|不，这不会删除您的表，如果确实有外键引用它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1400901|要获取引用您的表的所有外键关系，您可以使用以下SQL+(如果您使用的是SQL+Server2005或更高版本)：|1400902|SELECT+*+
FROM+sys.foreign_keys
WHERE+referenced_object_id+=+object_id('Student')|code-block|syntax|javascript|1400903|如果有的话，使用下面的语句，您可以创建SQL语句来实际删除这些FK关系：|1400904|SELECT+
++++'ALTER+TABLE+['+%2B++OBJECT_SCHEMA_NAME(parent_object_id)+%2B
++++'].['+%2B+OBJECT_NAME(parent_object_id)+%2B+
++++']+DROP+CONSTRAINT+['+%2B+name+%2B+']'
FROM+sys.foreign_keys
WHERE+referenced_object_id+=+object_id('Student')|1400905|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

No, this will not drop your table if there are indeed foreign keys referencing it.

To get all foreign key relationships referencing your table, you could use this SQL (if you're on SQL Server 2005 and up):

<pre><code>SELECT * 
FROM sys.foreign_keys
WHERE referenced_object_id = object_id('Student')
</code></pre>

and if there are any, with this statement here, you could create SQL statements to actually drop those FK relations:

<pre><code>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('Student')
</code></pre>

blocks|key|1400852|text|如果你先删除“孩子”表，外键也会被删除。如果您首先尝试删除"parent“表，您将得到一个”无法删除对象'a‘，因为它被外键约束引用“。错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1400853|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you drop the "child" table first, the foreign key will be dropped as well. If you attempt to drop the "parent" table first, you will get an "Could not drop object 'a' because it is referenced by a FOREIGN KEY constraint." error.

blocks|key|1185552|text|这是使用sp_MSdropconstraints过程正确删除所有表的另一种方法。我能想到的最短的代码是：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1185553|exec+sp_MSforeachtable+"declare+@name+nvarchar(max);+set+@name+=+parsename('?',+1);+exec+sp_MSdropconstraints+@name";
exec+sp_MSforeachtable+"drop+table+?";|code-block|syntax|javascript|1185554|entityMap^0|4|K|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Here is another way to drop all tables correctly, using <code>sp_MSdropconstraints</code> procedure. The shortest code I could think of:

<pre><code>exec sp_MSforeachtable "declare @name nvarchar(max); set @name = parsename('?', 1); exec sp_MSdropconstraints @name";
exec sp_MSforeachtable "drop table ?";
</code></pre>

blocks|key|1400829|text|如果是SQL+Server，则必须先删除约束，然后才能删除表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1400830|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If it is SQL Server you must drop the constraint before you can drop the table.

blocks|key|1185577|text|@mark_s发布的内容稍微更通用一些，这对我很有帮助|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1185578|SELECT+
'ALTER+TABLE+'+%2B++OBJECT_SCHEMA_NAME(k.parent_object_id)+%2B
'.['+%2B+OBJECT_NAME(k.parent_object_id)+%2B+
']+DROP+CONSTRAINT+'+%2B+k.name
FROM+sys.foreign_keys+k
WHERE+referenced_object_id+=+object_id('your+table')|code-block|syntax|javascript|1185579|只需插入您的表名，并执行它的结果。|1185580|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Slightly more generic version of what @mark_s posted, this helped me

<pre><code>SELECT 
'ALTER TABLE ' + OBJECT_SCHEMA_NAME(k.parent_object_id) +
'.[' + OBJECT_NAME(k.parent_object_id) + 
'] DROP CONSTRAINT ' + k.name
FROM sys.foreign_keys k
WHERE referenced_object_id = object_id('your table')
</code></pre>

just plug your table name, and execute the result of it.

blocks|key|1400940|text|下面是删除表本身所遵循的所有约束的另一种方法，使用涉及FOR+XML+PATH('')的连接技巧，该技巧允许将多个输入行合并到单个输出行。应该可以在任何SQL+2005或更高版本上运行。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1400941|为了安全起见，我把EXECUTE命令注释掉了。|1400942|DECLARE+@SQL+NVARCHAR(max)
;WITH+fkeys+AS+(
++++SELECT+quotename(s.name)+%2B+'.'+%2B+quotename(o.name)+tablename,+quotename(fk.name)+constraintname+
++++FROM+sys.foreign_keys+fk
++++JOIN+sys.objects+o+ON+fk.parent_object_id+=+o.object_id
++++JOIN+sys.schemas+s+ON+o.schema_id+=+s.schema_id
)
SELECT+@SQL+=+STUFF((SELECT+';+ALTER+TABLE+'+%2B+tablename+%2B+'+DROP+CONSTRAINT+'+%2B+constraintname
FROM+fkeys
FOR+XML+PATH('')),1,2,'')

--+EXECUTE(@sql)

SELECT+@SQL+=+STUFF((SELECT+';+DROP+TABLE+'+%2B+quotename(TABLE_SCHEMA)+%2B+'.'+%2B+quotename(TABLE_NAME)+
FROM+INFORMATION_SCHEMA.TABLES+
FOR+XML+PATH('')),1,2,'')

--+EXECUTE(@sql)|code-block|syntax|javascript|1400943|entityMap^0|R|G|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

Here's another way to do delete all the constraints followed by the tables themselves, using a concatenation trick involving <code>FOR XML PATH('')</code> which allows merging multiple input rows into a single output row. Should work on anything SQL 2005 &amp; later.

I've left the EXECUTE commands commented out for safety.

<pre><code>DECLARE @SQL NVARCHAR(max)
;WITH fkeys AS (
 SELECT quotename(s.name) + '.' + quotename(o.name) tablename, quotename(fk.name) constraintname 
 FROM sys.foreign_keys fk
 JOIN sys.objects o ON fk.parent_object_id = o.object_id
 JOIN sys.schemas s ON o.schema_id = s.schema_id
)
SELECT @SQL = STUFF((SELECT '; ALTER TABLE ' + tablename + ' DROP CONSTRAINT ' + constraintname
FROM fkeys
FOR XML PATH('')),1,2,'')

-- EXECUTE(@sql)

SELECT @SQL = STUFF((SELECT '; DROP TABLE ' + quotename(TABLE_SCHEMA) + '.' + quotename(TABLE_NAME) 
FROM INFORMATION_SCHEMA.TABLES 
FOR XML PATH('')),1,2,'')

-- EXECUTE(@sql)
</code></pre>

blocks|key|1400973|text|以下是实现解决方案的完整脚本：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1400974|create+Procedure+[dev].DeleteTablesFromSchema
(
++++@schemaName+varchar(500)
)
As+
begin
++++declare+@constraintSchemaName+nvarchar(128),+@constraintTableName+nvarchar(128),++@constraintName+nvarchar(128)
++++declare+@sql+nvarchar(max)
++++--+delete+FK+first
++++declare+cur1+cursor+for
++++select+distinct+
++++CASE+WHEN+t2.[object_id]+is+NOT+NULL++THEN++s2.name+ELSE+s.name+END+as+SchemaName,
++++CASE+WHEN+t2.[object_id]+is+NOT+NULL++THEN++t2.name+ELSE+t.name+END+as+TableName,
++++CASE+WHEN+t2.[object_id]+is+NOT+NULL++THEN++OBJECT_NAME(d2.constraint_object_id)+ELSE+OBJECT_NAME(d.constraint_object_id)+END+as+ConstraintName
++++from+sys.objects+t+
++++++++inner+join+sys.schemas+s+
++++++++++++on+t.[schema_id]+=+s.[schema_id]
++++++++left+join+sys.foreign_key_columns+d+
++++++++++++on++d.parent_object_id+=+t.[object_id]
++++++++left+join+sys.foreign_key_columns+d2+
++++++++++++on++d2.referenced_object_id+=+t.[object_id]
++++++++inner+join+sys.objects+t2+
++++++++++++on++d2.parent_object_id+=+t2.[object_id]
++++++++inner+join+sys.schemas+s2+
++++++++++++on++t2.[schema_id]+=+s2.[schema_id]
++++WHERE+t.[type]='U'+
++++++++AND+t2.[type]='U'
++++++++AND+t.is_ms_shipped+=+0+
++++++++AND+t2.is_ms_shipped+=+0+
++++++++AND+s.Name=@schemaName
++++open+cur1
++++fetch+next+from+cur1+into+@constraintSchemaName,+@constraintTableName,+@constraintName
++++while+@@fetch_status+=+0
++++BEGIN
++++++++set+@sql+='ALTER+TABLE+'+%2B+@constraintSchemaName+%2B+'.'+%2B+@constraintTableName%2B'+DROP+CONSTRAINT+'%2B@constraintName%2B';'
++++++++exec(@sql)
++++++++fetch+next+from+cur1+into+@constraintSchemaName,+@constraintTableName,+@constraintName
++++END
++++close+cur1
++++deallocate+cur1

++++DECLARE+@tableName+nvarchar(128)
++++declare+cur2+cursor+for
++++select+s.Name,+p.Name
++++from+sys.objects+p
++++++++INNER+JOIN+sys.schemas+s+ON+p.[schema_id]+=+s.[schema_id]
++++WHERE+p.[type]='U'+and+is_ms_shipped+=+0+
++++AND+s.Name=@schemaName
++++ORDER+BY+s.Name,+p.Name
++++open+cur2

++++fetch+next+from+cur2+into+@schemaName,@tableName
++++while+@@fetch_status+=+0
++++begin
++++++++set+@sql+='DROP+TABLE+'+%2B+@schemaName+%2B+'.'+%2B+@tableName
++++++++exec(@sql)
++++++++fetch+next+from+cur2+into+@schemaName,@tableName
++++end

++++close+cur2
++++deallocate+cur2

end
go|code-block|syntax|javascript|1400975|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Here is a complete script to implement a solution:

<pre><code>create Procedure [dev].DeleteTablesFromSchema
(
 @schemaName varchar(500)
)
As 
begin
 declare @constraintSchemaName nvarchar(128), @constraintTableName nvarchar(128), @constraintName nvarchar(128)
 declare @sql nvarchar(max)
 -- delete FK first
 declare cur1 cursor for
 select distinct 
 CASE WHEN t2.[object_id] is NOT NULL THEN s2.name ELSE s.name END as SchemaName,
 CASE WHEN t2.[object_id] is NOT NULL THEN t2.name ELSE t.name END as TableName,
 CASE WHEN t2.[object_id] is NOT NULL THEN OBJECT_NAME(d2.constraint_object_id) ELSE OBJECT_NAME(d.constraint_object_id) END as ConstraintName
 from sys.objects t 
 inner join sys.schemas s 
 on t.[schema_id] = s.[schema_id]
 left join sys.foreign_key_columns d 
 on d.parent_object_id = t.[object_id]
 left join sys.foreign_key_columns d2 
 on d2.referenced_object_id = t.[object_id]
 inner join sys.objects t2 
 on d2.parent_object_id = t2.[object_id]
 inner join sys.schemas s2 
 on t2.[schema_id] = s2.[schema_id]
 WHERE t.[type]='U' 
 AND t2.[type]='U'
 AND t.is_ms_shipped = 0 
 AND t2.is_ms_shipped = 0 
 AND s.Name=@schemaName
 open cur1
 fetch next from cur1 into @constraintSchemaName, @constraintTableName, @constraintName
 while @@fetch_status = 0
 BEGIN
 set @sql ='ALTER TABLE ' + @constraintSchemaName + '.' + @constraintTableName+' DROP CONSTRAINT '+@constraintName+';'
 exec(@sql)
 fetch next from cur1 into @constraintSchemaName, @constraintTableName, @constraintName
 END
 close cur1
 deallocate cur1

 DECLARE @tableName nvarchar(128)
 declare cur2 cursor for
 select s.Name, p.Name
 from sys.objects p
 INNER JOIN sys.schemas s ON p.[schema_id] = s.[schema_id]
 WHERE p.[type]='U' and is_ms_shipped = 0 
 AND s.Name=@schemaName
 ORDER BY s.Name, p.Name
 open cur2

 fetch next from cur2 into @schemaName,@tableName
 while @@fetch_status = 0
 begin
 set @sql ='DROP TABLE ' + @schemaName + '.' + @tableName
 exec(@sql)
 fetch next from cur2 into @schemaName,@tableName
 end

 close cur2
 deallocate cur2

end
go
</code></pre>

blocks|key|1401068|text|Removing+Referenced+FOREIGN+KEY+Constraints
Assuming+there+is+a+parent+and+child+table+Relationship+in+SQL+Server:

--First+find+the+name+of+the+Foreign+Key+Constraint:
++SELECT+*+
++FROM+sys.foreign_keys
++WHERE+referenced_object_id+=+object_id('States')

--Then+Find+foreign+keys+referencing+to+dbo.Parent(States)+table:
+++SELECT+name+AS+'Foreign+Key+Constraint+Name',+
+++++++++++OBJECT_SCHEMA_NAME(parent_object_id)+%2B+'.'+%2B+OBJECT_NAME(parent_object_id)+AS+'Child+Table'
+++FROM+sys.foreign_keys+
+++WHERE+OBJECT_SCHEMA_NAME(referenced_object_id)+=+'dbo'+AND+
++++++++++++++OBJECT_NAME(referenced_object_id)+=+'dbo.State'

+--+Drop+the+foreign+key+constraint+by+its+name+
+++ALTER+TABLE+dbo.cities+DROP+CONSTRAINT+FK__cities__state__6442E2C9;

+--+You+can+also+use+the+following+T-SQL+script+to+automatically+find+
+--and+drop+all+foreign+key+constraints+referencing+to+the+specified+parent+
+--+table:

+BEGIN

DECLARE+@stmt+VARCHAR(300);

--+Cursor+to+generate+ALTER+TABLE+DROP+CONSTRAINT+statements++
+DECLARE+cur+CURSOR+FOR
+SELECT+'ALTER+TABLE+'+%2B+OBJECT_SCHEMA_NAME(parent_object_id)+%2B+'.'+%2B+
+OBJECT_NAME(parent_object_id)+%2B
++++++++++++++++'+DROP+CONSTRAINT+'+%2B+name
+FROM+sys.foreign_keys+
+WHERE+OBJECT_SCHEMA_NAME(referenced_object_id)+=+'dbo'+AND+
++++++++++++OBJECT_NAME(referenced_object_id)+=+'states';

+OPEN+cur;
+FETCH+cur+INTO+@stmt;

+--+Drop+each+found+foreign+key+constraint+
++WHILE+@@FETCH_STATUS+=+0
++BEGIN
++++EXEC+(@stmt);
++++FETCH+cur+INTO+@stmt;
++END

++CLOSE+cur;
++DEALLOCATE+cur;

++END
++GO

--Now+you+can+drop+the+parent+table:

+DROP+TABLE+states;
--#+Command(s)+completed+successfully.|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1401069|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>Removing Referenced FOREIGN KEY Constraints
Assuming there is a parent and child table Relationship in SQL Server:

--First find the name of the Foreign Key Constraint:
 SELECT * 
 FROM sys.foreign_keys
 WHERE referenced_object_id = object_id('States')

--Then Find foreign keys referencing to dbo.Parent(States) table:
 SELECT name AS 'Foreign Key Constraint Name', 
 OBJECT_SCHEMA_NAME(parent_object_id) + '.' + OBJECT_NAME(parent_object_id) AS 'Child Table'
 FROM sys.foreign_keys 
 WHERE OBJECT_SCHEMA_NAME(referenced_object_id) = 'dbo' AND 
 OBJECT_NAME(referenced_object_id) = 'dbo.State'

 -- Drop the foreign key constraint by its name 
 ALTER TABLE dbo.cities DROP CONSTRAINT FK__cities__state__6442E2C9;

 -- You can also use the following T-SQL script to automatically find 
 --and drop all foreign key constraints referencing to the specified parent 
 -- table:

 BEGIN

DECLARE @stmt VARCHAR(300);

-- Cursor to generate ALTER TABLE DROP CONSTRAINT statements 
 DECLARE cur CURSOR FOR
 SELECT 'ALTER TABLE ' + OBJECT_SCHEMA_NAME(parent_object_id) + '.' + 
 OBJECT_NAME(parent_object_id) +
 ' DROP CONSTRAINT ' + name
 FROM sys.foreign_keys 
 WHERE OBJECT_SCHEMA_NAME(referenced_object_id) = 'dbo' AND 
 OBJECT_NAME(referenced_object_id) = 'states';

 OPEN cur;
 FETCH cur INTO @stmt;

 -- Drop each found foreign key constraint 
 WHILE @@FETCH_STATUS = 0
 BEGIN
 EXEC (@stmt);
 FETCH cur INTO @stmt;
 END

 CLOSE cur;
 DEALLOCATE cur;

 END
 GO

--Now you can drop the parent table:

 DROP TABLE states;
--# Command(s) completed successfully.
</code></pre>

blocks|key|1401161|text|一切都要简单得多。有一个关闭检查和打开检查的配置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1401162|例如，如果您使用的是MySQL，那么要关闭它，您必须写入SET+foreign_key_checks+=+0；|1401163|然后删除或清空该表，并重新启用检查集foreign_key_checks+=+1；|1401164|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

everything is much simpler. There is a configuration to turn off the check and turn it on.
For example, if you are using MySQL, then to turn it off, you must write SET foreign_key_checks = 0;
Then delete or clear the table, and re-enable the check SET foreign_key_checks = 1;

blocks|key|1185676|text|执行以下代码以获取阻止拖放的外键约束名称。例如，我以roles表为例。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1185677|++++++SELECT+*
++++++FROM+sys.foreign_keys
++++++WHERE+referenced_object_id+=+object_id('roles');

++++++SELECT+name+AS+'Foreign+Key+Constraint+Name',
++++++OBJECT_SCHEMA_NAME(parent_object_id)+%2B+'.'+%2B+OBJECT_NAME(parent_object_id)
++++++AS+'Child+Table'+FROM+sys.foreign_keys
++++++WHERE+OBJECT_SCHEMA_NAME(referenced_object_id)+=+'dbo'
++++++AND+OBJECT_NAME(referenced_object_id)+=+'dbo.roles'|code-block|syntax|javascript|1185678|你将会得到如下的FK名称：FK__Table1__roleId__1X1H55C1|1185679|现在运行下面的代码来删除从上面获得的FK引用。|1185680|ALTER+TABLE+dbo.users+drop+CONSTRAINT+FK__Table1__roleId__1X1H55C1;|1185681|完成了！|1185682|entityMap^0|Q|5|0|0|D|S|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|11|8|@]|D|@]|E|$]]|$1|O|3|P|5|H|7|12|8|@]|D|@]|E|$I|J]]|$1|Q|3|R|5|6|7|13|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|T|$]]

execute the below code to get the foreign key constraint name which blocks your drop. For example, I take the <code>roles</code> table. 

<pre><code> SELECT *
 FROM sys.foreign_keys
 WHERE referenced_object_id = object_id('roles');

 SELECT name AS 'Foreign Key Constraint Name',
 OBJECT_SCHEMA_NAME(parent_object_id) + '.' + OBJECT_NAME(parent_object_id)
 AS 'Child Table' FROM sys.foreign_keys
 WHERE OBJECT_SCHEMA_NAME(referenced_object_id) = 'dbo'
 AND OBJECT_NAME(referenced_object_id) = 'dbo.roles'
</code></pre>

you will get the FK name something as below : <code>FK__Table1__roleId__1X1H55C1</code>

now run the below code to remove the FK reference got from above.

<pre><code>ALTER TABLE dbo.users drop CONSTRAINT FK__Table1__roleId__1X1H55C1;
</code></pre>

Done!

blocks|key|1185765|text|查找所有外键..编写主题脚本|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1185766|SELECT+*++FROM+sys.foreign_keys
WHERE+referenced_object_id+=+object_id('Student')|code-block|syntax|javascript|1185767|然后从子表中删除外键。现在您可以删除父表了。|1185768|如果要重新创建父表，请确保运行之前创建的脚本。|1185769|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Find all foreign key.. script them
<pre><code>SELECT * FROM sys.foreign_keys
WHERE referenced_object_id = object_id('Student')
</code></pre>
and then delete foreign keys from child table.
now you can drop parent table .
if you want to recreate the parent table make sure to run the script you have created earlier.

blocks|key|1185608|text|如果要使用外键DROP已被其他表引用的表，请使用|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1185609|DROP+TABLE+*table_name*+CASCADE+CONSTRAINTS;|1185610|我想这对你来说应该是有效的。|1185611|entityMap^0|7|4|0|0|18|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|R|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|K|$]]

If you want to <code>DROP</code> a table which has been referenced by other table using the foreign key use 

<code>DROP TABLE *table_name* CASCADE CONSTRAINTS;</code> 
I think it should work for you.

If I want to delete all the tables in my database like this, will it take care of the foreign key constraint? If not, how do I take care of that first?

<pre><code>GO
IF OBJECT_ID('dbo.[Course]','U') IS NOT NULL
 DROP TABLE dbo.[Course]
GO
IF OBJECT_ID('dbo.[Student]','U') IS NOT NULL
 DROP TABLE dbo.[Student]
</code></pre>

SQL DROP TABLE foreign key constraint

SQL Server

数据库

MySQL

如果我想像这样删除数据库中的所有表，它会处理外键约束吗？如果不是，我该如何处理它呢？GOIF OBJECT_ID('dbo.[Course]','U') IS NOT NULL    DROP TABLE dbo.[Course]GOIF OBJECT_ID('dbo.[Student]','U') IS NOT NULL    DROP TABLE dbo.[Student]

问SQL DROP TABLE外键约束
EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL DROP TABLE外键约束EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL DROP TABLE外键约束
EN