query to get column names of table

query to get column names of particular table using sqlserver 2000

select name from SYSCOLUMNS where id=(select id from SYSOBJECTS where name='tablename')

SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

sql query to get column count of table-query to get number of columns in table

query to get number of columns of particular table using sqlserver

select count(*)as NOC from SYSCOLUMNS where id=(select id from SYSOBJECTS where name='tablename')