How do you get Column names only for a table (SQL Server)? Write the Query?

select name from syscolumns where id=(select id from sysobjects where name='user_hdr') order by colid //user_hdr is the table name
 

Search Topics

Popular Posts