SQL Server:
SELECT
sysobjects.name as "Table",
syscolumns.name as "Column"
from sysobjects , syscolumns
where sysobjects.id = syscolumns.id
and sysobjects.xtype = 'u'
and syscolumns.name like '%YourFieldNameGoesHere%'
order by sysobjects.name, syscolumns.name
----------------------------------------
--Get Table names and Row Counts
----------------------------------------
SELECT
[TableAndCount] = so.name +' - '+CAST(MAX(si.rows)asvarchar(10))+' Rows'
,
[Name] = so.name
FROM
sysobjects so,
sysindexes si
WHERE
so.xtype ='U'
AND si.id =OBJECT_ID(so.name)
and so.name notin('rvCustomer','rvOrder','sysdiagrams')
GROUP
BY
so.name
ORDER
BY
so.name
Sybase:
SELECT
sysobjects.name
as
"Table"
,syscolumns.name
as
"Column"
,sysobjects.type
from
sysobjects , syscolumns
where
sysobjects.id = syscolumns.id
and
sysobjects.type =
'U'
and
syscolumns.name
like
'%
YourFieldNameGoesHere
%'
order
by
sysobjects.name, syscolumns.name