How do you get Column names only for a table (SQ

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions

• What is Metadata and why should I use it?
• What are collection pools? What are the advantages?
• What are collection pools? What are the advantages?
• What is Metadata and why should I use it?
• Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
• What is a data source?
• How do you handle your own transaction ?
• What is a data source?
• How do you handle your own transaction ?
• When we will Denormalize data?
• More...