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

How will you know when statistics on a table are obsolete?

610

What is normalization? Explain different forms of normalization?

540

What are audit control procedures?

589

Mention what are the different types of ssrs reports?

What is raid, and how it can influence database performance?

580

Explain what is cte (common table expression)?

626

Write a program using SQL queries to find a unique entry in a table.

546

What is a database in ms sql server?

550

What is a join in sql? What are the types of joins?

525

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

510

Explain tables in SQL Azure?

What is explicit mode in sql server?

534

What is table level trigger?

586

What are some examples of schemas?

533

How will you monitor replication latency in transactional replication? : sql server replication

614