how to get all tables name with max. no of record count in database.

use yourDatabaseName
go
SELECT
T.TABLE_NAME AS [TABLE NAME], MAX(I.ROWS) AS [RECORD COUNT]
FROM SYSINDEXES I, INFORMATION_SCHEMA.TABLES T
WHERE T.TABLE_NAME = OBJECT_NAME(I.ID)
      AND T.TABLE_TYPE = 'BASE TABLE'
GROUP BY T.TABLE_SCHEMA, T.TABLE_NAME
order by [RECORD COUNT] desc

USE YOURDBNAME
GO
SELECT *
FROM sys.Tables