<p>Is there any query which can return me the number of revisions made to the structure of a database table?</p>

<p>Secondly, how can I determine the number of pages (in terms of size) present in mdf or ldf files?</p>

[{'answer_id': 39269, 'author': 'Christian Hagelid', 'author_id': 202, 'author_profile': 'https://Stackoverflow.com/users/202', 'pm_score': 2, 'selected': False, 'text': '<p>I think you need to create a <code>trigger</code> and store all changes to the table in a separate table. You can then use this table to get the revision history.</p>\n'}, {'answer_id': 39291, 'author': 'Matt Lacey', 'author_id': 1755, 'author_profile': 'https://Stackoverflow.com/users/1755', 'pm_score': 0, 'selected': False, 'text': "<p><code>SQL Server</code> doesn't keep track of changes so it can't tell you this.</p>\n\n<p>The only way you may be able to do this is if you had a copy of all the scripts applied to the database.</p>\n\n<p>In order to be able to capture this information in the future you should look at <code>DDL triggers (v2005+)</code> which will enable you to record changes.</p>\n"}, {'answer_id': 39311, 'author': 'pirho', 'author_id': 3911, 'author_profile': 'https://Stackoverflow.com/users/3911', 'pm_score': 2, 'selected': True, 'text': '<p>You can get last modify date or creation date of object in <code>SQL Server</code>.</p>\n\n<p>For examle info on tables:</p>\n\n<pre><code>SELECT * FROM sys.objects WHERE type=\'U\'\n</code></pre>\n\n<p><a href="http://msdn.microsoft.com/en-us/library/ms190324.aspx" rel="nofollow noreferrer">More info on msdn</a></p>\n\n<p>Number of pages can be fetched from <code>sys.database_files</code>.</p>\n\n<p><a href="http://msdn.microsoft.com/en-us/library/ms174397.aspx" rel="nofollow noreferrer">Check documentation</a></p>\n'}]
['https://Stackoverflow.com/questions/39243', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/4021/']