SELECT count(*) NoOfColumns FROM SYSCOLUMNS WHERE id= (Select id from SYSO

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

Question Posted / jerry joseph

Answer Posted / jerry joseph

SELECT count(*) NoOfColumns FROM SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'TableName')

Is This Answer Correct ?

14 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What are the functions in sql server?

903

What is clustered vs nonclustered index?

886

What is replication with database mirroring? : sql server database administration

988

What is the security principal at the database level that represents your session?

896

What is a Join and explain its types?

1051

What is the difference between functions and scalar functions?

1127

what is normalization? : Sql server database administration

1022

How do I find the transaction log size in sql server?

916

How do I connect to sql server database?

951

What are cursors stored procedures and triggers?

938

What is difference between rownum and row_number?

911

How do you rebuild an identity column?

896

How do you debug a procedure in sql server?

893

How can sql server instances be hidden? : sql server security

1055

how to create “alternate row colour”?

142