<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>

I think you need to create a
```
trigger
```
and store all changes to the table in a separate table. You can then use this table to get the revision history.