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 are the benefits of filtered indexes?

1040

How to return the date part only from a sql server datetime datatype?

1103

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

914

When you should use a low fill factor?

993

What is table constraint?

992

What is inner join in sql server joins?

1035

What are the hotfixes and patches in sql server?

1017

Mention the differences between local and global temporary tables.

1043

Explain transaction server consistency?

973

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

980

query processing

2172

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1033

how many type of indexing in database?

981

Explain about analysis services?

1049

explain what is raid and what are different types of raid configurations? : Sql server database administration

1002