SQL Server view table size,index size

How to view Table size , index size

View/show rows in table with out select

Use  "sp_spaceused"

Example 

Use myDB
GO

sp_spaceused "trans"

GO

How to view database information in SQL Server

Use master
GO

sp_helpdb "db_name"

GO


The result will seperate in 2 section
Section 1 : about overall database info , total size , status etc..
Section 2 : about data and log file , location , size etc..