This is a simple query for finding all instances of a column with a particular name along with the table that it belongs to. This will not work on SQL Server 2000. select sys.objects . name as TableName , sys.columns . name as ColumnName from sys.columns...