Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
Determine used fields/tables in databaseGreetings to all! I was curious if there was a way to determine what fields are in use by stored procedures and/or views in a database. If there's a way through SQL or through VB .NET, I would be most appreciative to learn about it. Thanks, Kyjan
Post Follow-up to this message
Re: Determine used fields/tables in database"Kyjan" <HolySaphAngel@gmail.com> wrote in message news:1141065761.449583.226070@u72g2000cwu.googlegroups.com... > Greetings to all! > > I was curious if there was a way to determine what fields are in use by > stored procedures and/or views in a database. If there's a way through > SQL or through VB .NET, I would be most appreciative to learn about it. > > Thanks, > > Kyjan > There may be an easier way, but you might look at how the sp_depends sproc does it. Rick Sawtell MCT, MCSD, MCDBA
Post Follow-up to this message Re: Determine used fields/tables in databaseThis way does not look at views. Is there a way to include those? Kyjan
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
