@Anshul.. Bro..through your code u can obtain the Total numbers of rows

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

Question Posted / dharmendra k. dixit

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

Answer Posted / dharmendra k. dixit

@Anshul..
Bro..through your code u can obtain the Total numbers of
rows in your Table.
---------------------------------

For getting Total Columns i will use this:

SELECT Count(*)As Coloumns
FROM Sys.SysColumns
Where ID =
(SELECT ID FROM Sys.SysObjects Where Name = 'YourTableName')

Is This Answer Correct ?

34 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is entity data services?

1067

What do you mean by SQL injection attack?

1067

What is the recursive stored procedure in sql server?

1021

What is report snapshot?

161

What is recompile sql server?

1041

What does man by sql wildcard characters in sql server?

1062

How can sql server instances be hidden?

977

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1027

Give me a SQL Query to find out the second largest company?

1167

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1010

What is isnull() operator?

1041

How to create a new schema in a database?

1151

What are trace flags?

1033

Can we perform backup restore operation on tempdb?

1017

Is null in sql server?

994