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

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

999

What is default constraint?

979

You want to implement the many-to-many relationship while designing tables. How would you do it?

982

What is the bookmark lookup and rid lookup?

986

How many database files are there in sql server 2000?what are they?

1031

What is tempdb database? : SQL Server Architecture

1168

If we delete pack Spec what will be the status of pack Body ?

1467

How secure is sql server database?

990

What is row_number()?

972

How to list all triggers in the database with sys.triggers in ms sql server?

1059

How to create indexed view?

1028

How to check table values in sql server?

944

Do you know the cursor types?

1147

Can you explain what is sql server english query?

981

What is the difference between update lock and exclusive lock?

962