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

Explain comment on transactions?

560

What is the difference between a clustered index and a non-clustered index?

536

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

592

Is it ok to shrink transaction log?

520

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

501

How to delete duplicate rows in sql server?

581

How to disable triggers using "disable trigger"?

568

How do you start single user mode in clustered installations?

526

What is cursor in ms sql server?

567

How fixed length strings are truncated and padded?

556

What is difference between views and stored procedures?

516

Write a SQL command to insert and update only a particular field?

637

How to create percentile function?

108

How do you implement session management in SQL Server mode?

562

How many types of schemas are there?

531