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 / amit

Answer Posted / amit

SELECT count(*) NoOfColumns FROM SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name
= 'TableName')

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What do you mean by a dependent functionality in a build?

1155

Define constraints and give an example of their use?

1041

What is sql azure database?

206

How do database indexes work?

1014

What is the difference between inner join and equi join?

998

Explain following error properties?

1023

Where to find ntwdblib.dll version 2000.80.194.0?

962

Explain syntax for dropping triggers?

934

How to end a stored procedure properly in ms sql server?

1092

How exceptions can be handled in sql server programming?

1017

Which table keeps the locking information?

931

What do you understand by the analysis services in sql server?

942

Can you insert NULL in unique column?

1167

How can a user-defined datatype be created?

988

What is the default order of an order by clause?

1001