December 4, 2004 at 2:50 pm
I have a table, buily with this SQ
CREATE TABLE dbo.Authors
(
Au_ID INT IDENTITY(1,1) NOT NULL,
Author NVARCHAR(50),
[Year Born] SMALLINT DEFAULT (0),
CONSTRAINT aaaaaAuthors_PK PRIMARY KEY NONCLUSTERED ( Au_ID )
)
----------------------
I tried to DROP it (DROP TABLE dbo.Authors)and it failed, because of this error from SQLExecMS, all other tables are deleted, except for this one.
Descr=Could not drop object 'dbo.Authors' because it is referenced by a FOREIGN KEY constraint.
SQLState=42S03
Number=-2147217900
Native Error=3726
Any ideas
December 4, 2004 at 2:58 pm
Well, the error message is pretty much self-describing. There you have another table referencing it. You need to drop that foreign constraint first in order to drop thast table.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
December 4, 2004 at 3:59 pm
I tried that but, it did not work
ALTER TABLE dbo.Authors NOCHECK CONSTRAINT ALL
Batch ran ok, then I attempted to DROP table, that got the above error message, any ideas
December 6, 2004 at 12:57 am
NOCHECK is not the same as DROP.
create table t
(
c1 int primary key
)
create table t1
(
c2 int constraint fk_me foreign key references t(c1)
)
drop table t
Server: Nachr.-Nr. 3726, Schweregrad 16, Status 1, Zeile 9
Das t-Objekt konnte nicht gelöscht werden, da eine FOREIGN KEY-Einschränkung auf das Objekt verweist.
Something like this should work:
create table t
(
c1 int primary key
)
create table t1
(
c2 int constraint fk_me foreign key references t(c1)
)
alter table t1 drop constraint fk_me
drop table t
drop table t1
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy