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 the query and subquery?

1070

How to create a user name in a database?

1039

How many non clustered indexes there can be on table ?

913

Explain about integration services of Microsoft SQL server?

1026

How and why use sql server?

995

Can we create clustered index on composite key?

1066

What is application role in sql server database security? : sql server security

1051

Describe different Processing Modes offered by SSRS?

248

How to list all dsn entries on your local machine using odbc_data_source()?

1028

What do you know about normalization and de- normalization?

917

How to insert a new row into a table with "insert into" statements in ms sql server?

959

Do you know data definition language, data control language and data manipulation language?

1034

how to define testing of network layers? : Sql server database administration

960

What is indexed view?

972

How can you set the threshold at which sql server will generate keysets asynchronously?

977