SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS where table

how to find number of columns in a table in sql server 2000
and 2005 also

Question Posted / surbhi

Answer Posted / surbhi

SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS where
table_name='tablename'

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain sql server authentication modes?

1186

Explain ranking functions?

1094

Explain nested trigger in sql?

1130

What are the different types of data sources in ssrs?

203

Explain the phases a transaction has to undergo?

1111

How to rebuild master databse?

1127

How to retrieve field values using mssql_result()?

1414

What is the default server name for sql server?

1230

Is it possible to replicate data from sql server to oracle? : sql server replication

1140

What are recommended options to be used while using db mirroring? : sql server database administration

1223

what are the critical issues you have resloved in your company

2016

What action plan is preferred if sql server is not responding?

1157

What is the difference between grant and with grant while giving permissions to the user?

1025

To which devices can a backup be created and where should these devices be located? : sql server management studio

1102

What is the definition for sql server 2000?

1137