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

What is use of except clause?

1073

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

1210

What is tcl in sql server?

1105

What is the function of sql server agent windows service?

1069

Why do we use non clustered index?

1063

What are built in functions?

984

What are the advantages of using a stored procedure?

993

What are some examples of schemas?

958

What are sql dirty pages?

1004

What do you do in data exploration

977

What is a join in sql?

1070

What happens if time-only values are provided as date and time literals?

995

What is log in sql server?

1128

How do I find the default sql server instance?

928

When I delete any data from a table, does the sql server reduce the size of that table?

996