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 clustered primary key?

958

What is dknf in normalization form?

983

What is 1nf 2nf?

962

What is pessimistic concurrency?

921

What the different topologies in which replication can be configured?

1022

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

969

What is the full form of dql?

927

How to delete database objects with "drop" statements in ms sql server?

1033

How to create function without parameter in sql server?

991

What are the operating modes in which database mirroring runs?

1025

what's the maximum size of a row? : Sql server database administration

1012

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

953

List the data types available in mssql?

957

What is exclusive locks?

916

What do you mean by normalisation?

962