my code stock.com

Snippet options

Download: Download snippet as check_database_statsdate.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

select
	'dbname' = db_name(),
	'tabname' = o.name,
	'xtype' = o.xtype,
	'idxname' = i.name, 
	'stats' = stats_date(i.id,i.indid),
	'rowcnt' = i.rowcnt,
	'dpages' = i.dpages
from 
	sysobjects as o 
	inner join 
	sysindexes as i 
	on o.id = i.id 
order by 
	o.name

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.