SELECT Count(*)As Coloumns FROM SysColumns Where ID = (SELECT ID FROM

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

Question Posted / vidit tyagi

Answer Posted / vidit tyagi

SELECT Count(*)As Coloumns
FROM SysColumns
Where ID =
(SELECT ID FROM SysObjects Where Name = 'TableName')

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to convert numeric expression data types using the cast() function?

1057

Write SQL queries on Self Join and Inner Join.

1146

What are the properties of the relational tables?

874

What are trace flags and mention a few common trace flags used with sql server?

1079

Can a rule be bound to any column of any data type?

954

How to delete multiple rows with one delete statement in ms sql server?

1001

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

997

How to connect to a sql server using odbc_connect()?

1141

How will you make an attribute not process? : sql server analysis services, ssas

1076

What part does database design plays a role in performance of an sql server-based application?

972

What is difference between delete and truncate commands?

1074

Explain nested trigger in sql?

1063

What is encryption key?

130

What is the difference between index seek vs. Index scan?

1020

What are types of storage modes? : sql server analysis services, ssas

1024