Find a which table a field is in ?

[Jamie2002]

Using SQL 6.5 how do I find which table a field is in if I have the field name ??

Also how do I list all tables and fields in the database, security levels is not an issue as we have no security or administrators set-up what-so-ever.


Thanks Thanks

Jamie

 

[osjohnm]

Hi

This should return all the tables when a column is specified:

select so.name
from sysobjects so, syscolumns sc
where so.id = sc.id
and sc.name = 'req_no'

This will return the table names and it's columns:

select so.name, sc.name
from sysobjects so, syscolumns sc
where so.id = sc.id

Hope it helps

John