Get the coulmn name from the view in sql server [Resolved]

SELECT v1.name

FROM sys.columns v1

INNER JOIN sys.views v2 on V1.OBJECT_ID = V2.OBJECT_ID

and V2.NAME = 'ViewName '

SELECT column_name AS ALIAS, data_type AS TYPE

FROM information_schema.columns 

WHERE table_name = 'ViewName'

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

SELECT c.NAME

FROM sys.columns c

JOIN sys.objects o ON c.OBJECT_ID = o.OBJECT_ID

where  type='V' AND o.NAME='ViewName '

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif