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

What is t-sql script to take database offline – take database online.

1022

Explain view in sql server?

1006

Where cross join is used?

904

What are the limitations in ssrs on sql server express edition?

175

What is an example of a primary key?

912

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

928

How to delete database objects with "drop" statements in ms sql server?

1033

Can we use pragma autonomous_transaction in trigger?

910

Explain system views?

1021

How do I find my localdb version?

939

What is statement level trigger?

935

what kind of lan types do you know? : Sql server database administration

924

How to create a scrollable cursor with the scroll option?

927

What does the update command do?

1051

What is cross join in sql server joins?

1074