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

Java database interview questions

(Continued from previous question...)

15. 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

Other Interview Questions

• How do you call a Stored Procedure from JDBC?
• Is the JDBC-ODBC Bridge multi-threaded?
• Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
• What is cold backup, hot backup, warm backup recovery?
• When we will Denormalize data?
• What is the advantage of using PreparedStatement?
• What is a “dirty read”?
• What is Metadata and why should I use it?
• What are different types of Transaction Isolation Levels?
• What is 2-phase commit?
• How do you handle your own transaction ?
• What is the normal procedure followed by a java client to access the db.?
• What is a data source?
• What are collection pools? What are the advantages?
• How do you get Column names only for a table (SQL Server)?