select count(*) NoOfColumns from SYSCOLUMNS WHERE id= (Select id from SYSO

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

Question Posted / kishore

Answer Posted / kishore

select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'city')

In this querry may name is Tablename

Is This Answer Correct ?

58 Yes

23 No

Please Help Members By Posting Answers For Below Questions

What is a functions and types in sql server?

1147

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

1039

What is the maximum size of column in sql server?

941

How do I find information about the install locations for the various instances running on a computer?

1123

Tell me about joins in database system and explain each in detail.

1105

How would you go about developing a ssrs report?

174

How can a database be repaired?

1032

Will sql server 2005 allow you to reduce the size of a column?

1054

Explain what are the different index configurations a table can have?

1160

What is the use of =,==,=== operators?

1057

What is 2nf normalization form?

1200

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

2008

How will you add a dimension to cube? : sql server analysis services, ssas

1136

can you instantiate a com object by using t-sql? : Sql server database administration

1041

what is the difference between Delete and Truncate command in SQL

1199