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

How to test odbc dsn connection settings?

1031

How to perform backup for certificates in sql server? : sql server security

1092

query processing

2166

Where are sql server usernames and passwords stored in the sql server?

1116

Where cross join is used?

960

What is snapshot replication?

1049

What is a view and what are its advantages?

1112

How you can change the database name in SQL SERVER?

1192

Where is localdb stored?

942

When to use Inner join & when to use subquery?

1161

Difference between DELETE and TRUNCATE?

1047

Can we use having clause without group by?

979

Sql server reporting services vs. Crystal reports.

131

What is the difference between drop table and truncate table?

924

How do you delete duplicate rows in sql server?

955