Select Rows From SysIndexes Where Id = Object

How do you find the number of rows in a table?

Question Posted / kumar.t

Answer Posted / kumar.t

Select Rows From SysIndexes Where Id = Object_Id
('tablename') And IndId<2

Uma Lakshman answer is wrong.

It Is Correct Answer

By
Kumar.T

Is This Answer Correct ?

12 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

974

What is it’s similarity with sql server?

160

Where the sql logs gets stored? : sql server database administration

970

What are the components of dbms?

954

Can group by and orderby be used together?

1016

Explain a checkpoint?

1042

what are the Prerequisites for Replication?

11355

When to use Inner join & when to use subquery?

1166

What is the difference between Clustered and Non-Clustered Index?

1060

What is the Disadvantage of indexed sequential file.

1084

Explain few examples of stored procedure over triggers?

1045

Explain the categories of stored procedure?

937

How can a database be repaired?

994

Explain what are magic tables in sql server?

1000

What is the dbcc command and why is it used?

1053