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

Difference between drill down and drill through report.

943

How to get nth highest salary from employee table.

1156

What is a database table?

960

What is 2nf normalization form?

1122

How to find the login name linked to a given user name?

1002

How do I find the default sql server instance?

931

do views contain data ?

950

Which tools are available to manage SQL Azure databases and servers?

115

How to use subqueries with the in operators in ms sql server?

1062

why would you call update statistics? : Sql server database administration

1073

What are the types of database recovery models?

1108

How to verify a user name with sqlcmd tool?

1067

How to find table changes in sql server?

1105

How can sql server instances be hidden? : sql server security

1129

What are the differences between ms sql server & oracle?

1047