The information is stored in the datafile headers. To reveal it you will have to use the DBCC command and redirect the information to the trace output (by default this will be send to the errorlog) by using the following command:
DBCC TRACEON(3604)
After that you free to use one of the following commands:
DBCC DBINFO (information of the current database you are executing from)
DBCC PAGE(‘YourDatabaseHere’1,9,3) (Whereas “YourDatabaseHere’1” is you database to check for)
to will get you the following information:

Read more: Developer hearted / Relational minded