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 function of sql server agent windows service?

1045

What is query and its types?

882

What are drillthrough reports?

146

What is a not null constraint?

995

Can you leave a union at any time?

1021

What is difference between equi join and natural join?

980

What are triggers? How do you invoke a trigger on demand?

1256

What are the advantages of sql azure?

140

How to drop existing indexes in ms sql server?

1029

How do you open a cluster administrator?

1016

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

135

What is a non equi join?

923

What is a hint?

945

Can a function call a stored procedure in sql server?

924

Where views are stored in sql server?

937