@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
30469 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

How to remove duplicate rows from table?

1239

what data regions are and what are the different data regions?

141

How to change server name in sql server?

1172

How to assign new column names in a view?

909

What is history table in sql server?

957

Does a full backup include transaction log?

959

Explain the difference between control flow and data flow?

984

What is database dimension? : sql server analysis services, ssas

1069

What are the benefits and tasks of object explorer? : sql server management studio

1171

What is data modification?

952

How to create a new login name in ms sql server?

1051

What are commit and rollback in sql?

1115

whats the maximum size of view state??

2185

What is importing utility?

978

What is Transparent Data Encryption?

994