Finding Field Name in Multi Tables 1

[WurzelGummidge]

Is there a statetment that finds a field name (ie SECCODEID) in all the tables across a SQL DB ?

 

[sunila7]

Try this:

SELECT * from Information_Schema.Columns where COLUMN_NAME= 'SECCODEID'

Sunil

 

[WurzelGummidge]

That is perfect - i may be pushing my luck here but, further to your answer, how would i construct a sql statement that did the following:

Where ANY table has the field SECCODEID = 'abc123'
update SECCODEID to equal 'xyz321'

 

[sunila7]

Try this:

SELECT 'UPDATE [' + Table_name + '] SET SECCODEID = ''xyz13'' where city=''abc13'''
from Information_Schema.Columns where COLUMN_NAME= 'SECCODEID'


This select statement should give u the SQL to update in the o/p window in QA. Copy all the SQL's and run it in QA.

Hope this helps

Sunil

 

[WurzelGummidge]

Thanks once again, simple, straightforward, works-first-time answers that we all hope for but much too often get over-complicated.

EXCELLENT