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

Why use update_statistics command in sql server?

1113

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1059

What are the results of running this script?

975

What is difference between inner join and join?

1096

Why we need sql server?

1015

What is sql server profiler?

1062

What are the commands used in DCL?

1082

What is the purpose of the master database?

1199

What is the largest component inside a field?

1189

Explain what is the difference between a local and a global temporary table?

1047

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

996

Please explain go command in sql server?

1112

How sql server executes a statement with nested subqueries?

1093

what's the maximum size of a row? : Sql server database administration

1164

What is the use of stored procedure?

981