SQL Server 2008 introduces the ability to ... DROP TABLE SalesHistory; GO If you want to view other types of table type definitions in your system, you can execute the following query, which ...

Having that history also lets you "roll forward" through time to see how your data has changed, either to do trending analysis or to recover from some unfortunate event. To use this feature all you ...

Connect to your SQL Server instance, then in the object explorer pane drill down and highlight a container, such as Tables. Then click View => Object Explorer Details from the top menu bar.