finding a field

[markSaunders]

what is the best method of locating the tables in which a specific field is the primart key?

i'm trying to analyse a db passed to me and i have a field, say xID, and need to check in which tables it is used.

thanks
m Mark Saunders

 

[tlbroadbent]

This will search all tables and views.

Select * From information_schema.columns
Where column_name='xID'

You can search stored procedures by searching the syscomments table.

Select * From syscomments
Where text like '%xID%'

A couple of stored procedures have been developed and uploaded on SWYNK.com. You can find them on this page.

http://www.swynk.com/sqlscripts/maintenance7.asp

Download findText.sql and/or WhereAmI.sql. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[markSaunders]

thanks for that - just the ticket!
mark Mark Saunders