Friday, March 13, 2009

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

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

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

No comments: