Query a DB for a field value on SQL 2005 STD SP2

[Hulicat]

This does not seem to work; I dont know which table the value is in. USE DB Go SELECT * FROM sys.Tables where fieldid = '%' GO I presume I cannot use a conditional clause in that statement? It will parse but errors out

Regards, Hulicat

[David Mujica]

This is what I would use ...

select SO.NAME AS TABLENAME, SC.NAME AS COLNAME
from sysobjects so, syscolumns sc
where so.id = sc.id and sc.name = 'DESCRIPTION'

This query will give you a listing of every table that has a field that is named, 'DESCRIPTION'. Good luck, david

[Hulicat]

Thanks!

Regards, Hulicat