The following SQL Script enables you to search the database for where a particular column exists. This script can be very useful in troubleshooting error messages or just searching for where a particular field may exist.

It is possible to use SQL wildcard's (the % character, for example, to replace multiple characters) to enable broader searching – the script includes these wildcards for your convenience.

Copy and paste the script below into your SQL database, replacing **** in the script with the column name.

Select sysobjects.name, syscolumns.name

from sysobjects inner join syscolumns on syscolumns.id = sysobjects.id

Where sysobjects.xtype <> 'v'

and syscolumns.name like '%****%'