IN SQLSERVER 20005 SELECT COUNT(COLUMN_NAME) FROM INFORMATION

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

Question Posted / sudhir kumar

Answer Posted / sudhir kumar

IN SQLSERVER 20005

SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'TABLENAME'

try in sql server 2000

Is This Answer Correct ?

29 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is normalization process?

1179

How extra digits are handled with numeric data type literals?

966

What is the difference between clustered and a non-clustered index?

1028

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1007

Explain what is meant by replication of database?

1032

What are the elements of dbms?

967

What can be used instead of trigger?

1156

Does union all remove duplicates?

1064

How to create an multi-statement table-valued function?

996

Can you edit the .rdl code associated with a linked report?

163

Difference between uniqe index and uniqe constraint?

981

what authentication modes does sql server support? : Sql server database administration

1109

What do you understand by replication in sql server?

1061

What are the different types of sub-queries?

1043

What is a non-clustered index?

998