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

16 Answers
29951 Views
Virtusa, I also Faced
E-Mail Answers

Answer Posted / surbhi

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

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to backup encryption key ?

167

Explain comment on transactions?

933

Explain about thread and memory management process of SQL?

922

What is log cache in sql server?

977

How to view existing indexes on an given table using sp_help?

1050

What is intellisense?

988

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

897

Define indexes?

993

Explain what are sparse columns?

928

Tell me about joins in database system and explain each in detail.

1002

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2153

What is the log shipping?

952

Differentiate between sql temp table vs table variable?

827

How to sort query output in descending order in ms sql server?

899

What is query optimizer in sql server?

956