SELECT COUNT(*) FROM SYS.COLUMNS WHERE ID=(SELECT * FROM SYS.OBJECT WHERE

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

Question Posted / ram&saran

Answer Posted / ram&saran

SELECT COUNT(*) FROM SYS.COLUMNS WHERE ID=(SELECT * FROM
SYS.OBJECT WHERE NAME='TABLENAME')

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to check table values in sql server?

952

How optimize sql query with multiple joins in sql server?

891

Can one drop a column from a table?

1014

Do you know what is similarity and difference between truncate and delete in sql?

1001

Is candidate a key?

945

What is the maximum number of index per table?

1067

What is an execution plan?

1136

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

934

What are the basic features of a trigger in ms sql server?

1181

Do you know hot add cpu in sql server 2008?

949

Can you explain what are commit and rollback in sql?

930

What is the order in which the sql query is executed?

934

Explain about system stored procedure?

1027

What is reportserver and reportservertempdb ?

152

Explain the difference between cross join and full outer join?

977