quote:

---

Originally posted by rockmoose

Have you tried, in no particular order:

1. sp_help, or sp_helpconstraint on the table
2. scripting the table with all the constraints to see if you find it
3. in QA view the Constraints defined on the table. ( you can do this in the objectbrowser )

/rockmoose

---

select * from sysreferences
where fkeyid not in( select id from sysobjects )
or rkeyid not in( select id from sysobjects )

select * from sysconstraints
where id not in( select id from sysobjects )

set nocount on

-- create storage place for object id that we are about to delete from sysobjects
create table #missing_table( id int not null primary key )


-- create tables with reference
create table pktbl(id int not null primary key)
create table fktbl(id int not null primary key, pktbl_id int not null references pktbl(id) )

-- store away id of fktble
insert #missing_table(id) select object_id('fktbl')



exec sp_helpconstraint 'pktbl'

/*
Table is referenced by foreign key            
----------------------------------------------
MV.dbo.fktbl: FK__fktbl__pktbl_id__1F10398A
*/

delete sysobjects where id = ( select id from #missing_table )

drop table pktbl
/*
Server: Msg 3726, Level 16, State 1, Line 1
Could not drop object 'pktbl' because it is referenced by a FOREIGN KEY constraint.
*/

exec sp_helpconstraint 'pktbl'
/*
Table is referenced by foreign key                                                                                                                                                                                                                                                                           
----------------------------------------------
NULL
*/

delete sysreferences where fkeyid = ( select id from #missing_table )
delete sysconstraints where id = ( select id from #missing_table )

exec sp_helpconstraint 'pktbl'
/*
No foreign keys reference this table.
*/


drop table pktbl
/*
The command(s) completed successfully.
*/


-- cleanup
drop table #missing_table