Finding a particular column in All tables

Question

Viewing 4 posts - 1 through 3 (of 3 total)

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

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 1

or

select object_name(object_id) as table_name from sys.columns

where name='column_name' and objectproperty(object_id,'istable')=1

Madhivanan

Failing to plan is Planning to fail

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 2

try like:

select*

fromINFORMATION_SCHEMA.COLUMNS

whereCOLUMN_NAME = 'your column name'

go

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 3

Kishore.P (11/6/2008)
try like:
select*
fromINFORMATION_SCHEMA.COLUMNS
whereCOLUMN_NAME = 'your column name'
go

It would return View also

Madhivanan

Failing to plan is Planning to fail

Cookies on SQLServerCentral