Wednesday, September 21, 2011

To know whether the column exists in the particular database or not

select
o.name,c.name
from sys.columns c
inner join sys.objects o on c.object_id=o.object_id where c.name='Email'