Find a field name in all the tables of a database

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 1

Check out the system views sys.columns or information_schema.columns.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

dolly-829405 Valued Member Points: 74 More actions · Answer 2

hi

here is solution

SELECT SO.NAME AS "Table Name", SC.NAME AS "Column Name", SM.TEXT AS "Default Value"

FROM dbo.sysobjects SO INNER JOIN dbo.syscolumns SC ON SO.id = SC.id

LEFT JOIN dbo.syscomments SM ON SC.cdefault = SM.id

WHERE SO.xtype = 'U'

ORDER BY SO.[name], SC.colid

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

Much easier:

Select * From INFORMATION_SCHEMA.COLUMNS

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Venkatesan Prabu SSCommitted Points: 1892 More actions · Answer 4

Hope this will help you,

select * from sys.columns a inner join sys.objects b on a.object_id=b.object_id

where a.[name] = 'last_update_by'

Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:

http://venkattechnicalblog.blogspot.com/

Teresita Castro SSCommitted Points: 1568 More actions · Answer 5

SSCommitted

Points: 1568

July 27, 2008 at 1:50 pm

Thanks for all your hep!!!!