sql server new users: Is there a query command that will detect whether or not a table row has any
foreign key entries that would prevent deletion?

Thanks,

Keith

WHERE EXISTS is your friend:

select
*
from
MyTable m
where
-- put your search criteria here
and exists
(
select
*
from
OtherTable o
where
o.FK = m.PK
)

Use one EXISTS predicate per referencing table.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
[quoted text, click to view]
Is there a query command that will detect whether or not a table row has any
foreign key entries that would prevent deletion?

Thanks,

Keith