SQL Server Search for table with x [field]
By on 11-Jan-10 09:11
This query will search the system tables to find a specific field.
Thanks to http://vstoolsforum.com/blogs/sqlserver/archive/2007/01/11/find-tables-that-contain-a-certain-field.aspx for the query
select sysobjects.name, *
from syscolumns
left join sysobjects on sysobjects.id = syscolumns.id
where syscolumns.name like '%table%'
order by 1
Write a comment
- Required fields are marked with *.