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 ssrs maintain security?

1072

How to display a past time in days, hours and minutes?

1009

What are the basic functions for master, msdb, model, tempdb and resource databases?

974

What are logical/boolean operations in ms sql server?

1028

how to trace the traffic hitting a sql server? : Sql server database administration

1858

What is query and its types?

905

Mention the different types of triggers?

1098

Can we write trigger for view?

998

Describe different Processing Modes offered by SSRS?

248

What is the command used to check locks in microsoft sql server?

1037

List the ways in which dynamic sql can be executed?

1010

What is pivot and unpivot?

1005

What is a raid and what are different types of raid configurations?

1256

What is dbcc?

1128

How to create a Master database in SQL server ?

1074