use sp_depends


----- Original Message -----
From: "Shibu MB" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, December 26, 2002 8:38 PM
Subject: Script to find child tables


Hi Friends ..

HAPPY NEW YEAR !!!!!!!

Can anyone share the query to find all the child tables of a table??


Thanks
Shibu


MS Sql Server LazyDBA home page