|
Home > Archive > MS SQL Server > February 2006 > Determine used fields/tables in database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Determine used fields/tables in database
|
|
|
| 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
| |
| Rick Sawtell 2006-02-28, 8:23 pm |
|
"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
| |
|
| This way does not look at views. Is there a way to include those?
Kyjan
|
|
|
|
|