Not Able to drop a table..Please help me out

[Former Member]

While trying to delete from a table got below error:

The 'delete' statement will not be executed because the cross-database referential constraint on table 'ims24_fits..e_fit_trade' cannot be enforced. A table or constraint definition is missing in database 'global'. Contact your System Administrator.

Msg: 436, Level: 16, State: 1

Below is the details of sp_helpconstraint:

name

definition

created

--------------------------- -------------------------------------------------------------------------------- -------------------

e_fit_trad_buy_se_459864705 DEFAULT  'N'	Jun  2 2001  2:33AM
*	global.. FOREIGN KEY (*) REFERENCES e_fit_trade(seqno)	NULL

e_fit_trad_seqno_1890925908 e_fit_trade_discrepancy_reason FOREIGN KEY (seqno) REFERENCES e_fit_trade(seqno) Mar 17 2015 11:23AM

XPK_e_fit_trade

PRIMARY KEY INDEX ( seqno) : CLUSTERED, FOREIGN REFERENCE

Mar 16 2015  3:47PM

The Second constraint is NULL.

It's not even letting me to delete the table.

Please advise....