select count(*) from syscolumns sy,Sysobjects so where sy.id =so.id

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

Question Posted / ajit kumar nayak

Answer Posted / ajit kumar nayak

select count(*) from syscolumns sy,Sysobjects so
where
sy.id =so.id
and so.name = <table name>

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to list all login names on the ms sql server?

1147

What is a non-clustered index?

1001

Data table as parameter in sql server?

1052

what is a correlated sub-query? : Sql server database administration

948

What are the differences between decimal and float in ms sql server?

1255

How can you fetch alternate records from a table?

965

What are the elements of dbms?

970

What is normalization according to you and explain its different levels?

957

What is 1nf 2nf and 3nf?

893

How to implement service broker?

1017

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1686

How do I trace a query in sql server?

959

What are the different types of cursor?

1098

What is the difference between indexing and hashing?

1175

List the advantages of using stored procedures?

1061