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 are the fixed server level roles? : sql server security

1108

What is the difference between inner join and equi join?

974

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

949

What is etl - extraction, transformation, and loading?

905

Is the order of columns in the set clause important in ms sql server?

954

What are sql dirty pages?

1004

What happens if date-only values are provided as date and time literals?

1007

Explain the concept of view and Types of views in SQL server?

973

Explain about link server in sql server?

1036

Determine how to use the inserted and deleted pseudo tables?

974

Where sql server user names and passwords are stored in sql server? : sql server database administration

1035

How to backup encryption key ?

180

Can we do dml on views?

943

What is field with example?

909

Why olap is used?

955