I would take a guess here. If by 'child tables' he means
foreign key relationships, Wouldn't just sp_help 'tablename' work ?

Moreover, sp_depends is used to find out dependencies between
tables / views -> stored procs / views (OR) Vice versa

John
www.ideo.com

-----Original Message-----
From: Bindu Reddy [mailto:[Email Address Removed] December 30, 2002 12:58 PM
To: LazyDBA.com Discussion
Subject: Re: Script to find child tables


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



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page