retiveig columns

[yuvachandra]

hi all.... plz let me know how to retrieve the column name of a given table.....without content(data),just only column names not like select * from sometable and sp_help sometable Plz help me,,thanqs in advance:rose:

[Krish KP]

declare @tblname varchar(100) set @tblname = 'mytable' select * from syscolumns where id = (select id from sysobjects where name = @tblname)

Regards KP

[yuvachandra]

actually i want to bind the column names with a grid on the webpage...here i don't want any content...it giving some information along with the columns...anyway thanqs for ur kind reply MR krish

[Krish KP]

while retrieving data to grid use select query which returns no rows like SELECT * FROM tblA WHERE 1 = 2 this should work (I've not tried this.)

Regards KP