How to locate non-used table fields
- From: MickeyVip <mickey.vip@xxxxxxxxx>
- Date: Sun, 26 Aug 2007 07:08:32 -0700
Hello,
I would like to know if there is a way to know if a table field(s) is
(are) used by application or stored procedures.
I have an old DB with some tables. Those tables have fields, that were
in use once - data was written into and read from them by application
and stored procedures.
The new application and stored procedures do not use some of those
fields.
Is there a way to find out what fields are "obsolete"?
Thanks in advance.
.
- Follow-Ups:
- Re: How to locate non-used table fields
- From: sekharsql
- Re: How to locate non-used table fields
- Prev by Date: XML templates in SQL Server 2005
- Next by Date: Linked server doesn't work anymore
- Previous by thread: XML templates in SQL Server 2005
- Next by thread: Re: How to locate non-used table fields
- Index(es):