Answers

Question and Answer:

  Home  Java Database

⟩ 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

 173 views

More Questions for you: