sp_help tablename another command is select name from syscolum

how to find number of columns in a table in sql server 2000
and 2005 also

Question Posted / naren

Answer Posted / naren

sp_help tablename

another command is

select name from syscolumns where id=object_id
('table_name')

Is This Answer Correct ?

6 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the purpose of the model database?

1006

How many types of built in functions are there in sql server 2012?

910

Distinguish between nested subquery and correlated subquery?

1026

What are trace flags?

1013

Do comments need to go in a special place in sql server 2005?

846

Explain the disadvantages of cursors?

1124

What is log cache in sql server?

1024

What is database white box testing?

1109

What is the difference between executequery () and executeupdate ()?

1012

What is difference between temp table and cte?

1004

Tell me what is the stuff and how does it differ from the replace function?

969

What is the purpose of indexing?

1030

How do I find my localdb version?

971

Difference between LEN() and DATALENGTH() in sql server ?

1088

Is sql different from sql server?

1059