Tuesday, 18 June 2013

select statement for retriving only column names in a table

Ex1:

SELECT  *  FROM yourTableName WHERE 1=0

Ex2:


select
a.[name]
from
sys.columns a join sys.tables b on
a.object_id = b.object_id
where
b.[name] = 'YourTableName'

No comments:

Post a Comment