<div>
<br />

<pre><code id="code-475396">select 
	t.name
from 
	sysobjects t
	inner join sys.columns c on c.object_id = t.id
where
	c.name like ('%PreviousPatientProfileId%')
</code></pre>
</div>





select 
	t.name
from 
	sysobjects t
	inner join sys.columns c on c.object_id = t.id
where
	c.name like ('%PreviousPatientProfileId%')


<div>
Use this<br />

<pre><code id="code-475401">USE &lt;YOUR DATABASE&gt;;
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE
COLUMN_NAME = 'PreviousPatientProfileId';
</code></pre>
</div>


Use this


USE <YOUR DATABASE>;
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE
COLUMN_NAME = 'PreviousPatientProfileId';


<div>
I would Also suggest:<br />
(This will search all your stored procs to see if you are using the field there as well<br />
<br />

<pre><code id="code-475407">declare @Text nvarchar(100)
set @Text = '%PreviousPatientProfileId%'

SELECT OBJECT_NAME(id) 
    FROM syscomments 
    WHERE [text] LIKE @Text
    AND OBJECTPROPERTY(id, 'IsProcedure') = 1 
    GROUP BY OBJECT_NAME(id)</code></pre>
</div>


I would Also suggest:
(This will search all your stored procs to see if you are using the field there as well



declare @Text nvarchar(100)
set @Text = '%PreviousPatientProfileId%'

SELECT OBJECT_NAME(id) 
    FROM syscomments 
    WHERE [text] LIKE @Text
    AND OBJECTPROPERTY(id, 'IsProcedure') = 1 
    GROUP BY OBJECT_NAME(id)

<div>
<div class="content wysiwyg-content">
How can I scan all my tables against my db and find the ones that contain a specific fieldname? I want to find all instances were I have a field name &quot;PreviousPatientProfileId&quot;<wbr /><br />
<br />

</div>
</div>


How can I scan all my tables against my db and find the ones that contain a specific fieldname? I want to find all instances were I have a field name "PreviousPatientProfileId"



SQL 2005 Coding question

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.