SELECT DISTINCT SYS.NAME,COUNT(*) FROM SYSOBJECTS SYS INNER JOIN SYSCOLUMN

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

Question Posted / sujitha

Answer Posted / sujitha

SELECT DISTINCT SYS.NAME,COUNT(*) FROM SYSOBJECTS SYS
INNER JOIN SYSCOLUMNS SYSCOL ON SYSCOL.ID=SYS.ID
WHERE SYS.XTYPE='U' GROUP BY SYS.NAME

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

List some case manipulation functions in sql?

965

What is meant by dirty read?

947

Explain what are partitioned views and distributed partitioned views?

889

Mention what are the core components of ssrs?

296

How you can find out if an index is useful to the optimizer?

870

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

956

How to find index size for each index on table?

959

What are logical/boolean operations in ms sql server?

975

How do I run a trace in sql server?

928

Explain what is the difference between union and union all?

950

What is sql server schema compare? How we can compare two database schemas?

958

Does union all remove duplicates?

1015

How does clustered and non clustered index work?

848

What are the methods used to protect against sql injection attack?

999

If user is owning any SQL Objects, can we drop that user

2003