SQL count rows in a table

Question

I need to send a SQL query to a database that tells me how many rows there are in a table  I could get all the rows in the table with a SELECT and then count them  but I don t like to do it this way  Is there some other way to ask the number of the rows in a table to the SQL server

User · Accepted Answer

Yes  SELECT COUNT    FROM TableName

User · Answer

select sum  rows   from sys partitions where object id object id  tablename    and index id in  0 1    is very fast but very rarely inaccurate

User · Answer

Why don t you just right click on the table and then properties -  Storage and it would tell you the row count   You can use the below for row count in a view  SELECT SUM  row count   FROM sys dm db partition stats  WHERE object id OBJECT ID  Transactions       AND  index id 0 or index id 1

User · Answer

Here is the Query select count    from tablename  or select count rownum  from studennt

User · Answer

Use This Query    Select     S name         T name As TableName       SUM  P rows   As RowCont   From sys tables As T     Inner Join sys partitions As P On   P OBJECT ID   T OBJECT ID       Inner Join sys schemas As S On   T schema id   S schema id   Where       T is ms shipped   0       AND        P index id IN  1 0        And       T type    U     Group By S name   T name   Order By SUM  P rows   Desc

User · Answer

The index statistics likely need to be current  but this will return the number of rows for all tables that are not MS SHIPPED   select o name  i rowcnt  from sys objects o join sys sysindexes i  on o object id   i id where o is ms shipped   0 and i rowcnt  gt  0 order by o name

[sql-server] SQL count rows in a table

Examples related to sql-server

Examples related to count

Examples related to rows

Examples related to database-table