search for a field in SQL 1

[jorg32]

Hi,

Can somebody tell me how I can find 1 specific field in several tables in a SQL-Database?

Thank you for helping me.

Jorg

 

[vongrunt]

Go to query analyzer, press F4, type field name into "Object name", choose database, uncheck "All object types", check "Column", start search.

 

[jorg32]

Thanks for your help!

Can I ask you another question about the same case?

Is it also possible to get the "Data Type" + "Length" of this field?

Jorg

 

[vongrunt]

AFAIK not this way... try:

select * from information_schema.columns where column_name = 'your_field_name'

 

[hmckillop]

try

select * from information_schema.columns
where column_name = 'columnname'

"I'm living so far beyond my income that we may almost be said to be living apart