This DBCC SHOWFILESTATS command provides you with the data files for the current database that you select. DBCC SHOWFILESTATS or DBCC SHOWFILESTATS WITH NO_INFOMSGS will display the current database File Name, Database Name, Total Extend, Used Extent, Field ID and File Group. To translate the extent into KB, divide the extent number by 16.
DBCC SHOWFILESTATS
