SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS where table

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

Question Posted / surbhi

Answer Posted / surbhi

SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS where
table_name='tablename'

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What happens if we shrink log file in sql server?

930

When does a workload on SQL Azure get throttled?

129

What stored procedure can you use to display the current processes?

850

Explain the properties of subqueries in sql server?

1034

What is the cartesian product of table?

942

What's the information that can be stored inside a bit column?

954

Mention what are the different types of ssrs reports?

146

How many replicas are maintained for each sql azure db?

124

What is the difference between writing data to mirrored drives versus raid5 drives

879

How except clause is differs from not in clause?

911

How to create a simple user defined function in ms sql server?

986

What are the restrictions that views have to follow? : SQL Server Architecture

956

What happens on checkpoint?

984

Explain the dirty pages?

963

How will you know when statistics on a table are obsolete?

1044