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 / amit

Answer Posted / amit

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

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can we check locks in database? If so, how can we do this lock check?

984

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1997

What are the fixed server level roles? : sql server security

1216

What are the steps you must follow to hide sql server instances?

1023

How many ways to create table-valued functions?

1054

is there a column to which a default can't be bound? : Sql server database administration

1050

How to achieve Paging of records in SQL SERVER?

1140

what changed between the previous version of sql server and the current version? : Sql server database administration

1052

What is transact-sql ddl trigger?

1148

How to name query output columns in ms sql server?

1013

What are the joins in sql server? : sql server database administration

1050

What are the functions in sql server?

989

Find first and last day of current month in sql server

1080

How you trouble shoot when any job fails

1981

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1132