select count(*) from syscolumns where id=(select id from Sysobjects where

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

Question Posted / bhaskar

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

Answer Posted / bhaskar

select count(*) from syscolumns where id=(select id from
Sysobjects where [name]='Table_Name')

Is This Answer Correct ?

13 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

914

What is table value parameters (tvp)?

1032

What is right outer join in sql server joins?

1116

How do I view a stored procedure in sql server query?

884

What are acid properties of transaction?

889

Define clusters?

993

What do you mean by cardinality?

846

What are the different index configurations a table can have?

896

What do you do in data exploration

926

Write an SQL query to obtain the 2nd highest salary.

1018

What are truncate options available in sql server? : sql server database administration

965

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

951

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1084

Explain a checkpoint?

970

Is natural join and equi join same?

909