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

What is bulkcopy in sql?

953

What is filtered index?

1106

What is analysis service repository?

1028

How to provide default values to function parameters?

1148

Do you know how to send email from database?

1015

Define normalisation?

1118

Which are the important points to note when multilanguage data is stored in a table?

1007

Does a specific recovery model need to be used for a replicated database? : sql server replication

971

whats the maximum size of view state??

2194

How to create a new schema in a database?

1161

How to list all user names in a database?

1061

What is BCP? When does it used in sql server 2012?

1069

What are different types of schemas?

950

what is a schema in sql server 2005? : Sql server database administration

1037

Explain the difference between primary keys and foreign keys?

1036