I thought that I would cover some of the great extensions that make ADS so much more, one that is quite nifty and I can see a use for is the data scripter extension.
This extension was written by Sean Price and also the db snapshot tool ( which is very useful as well) the github link is here
1) So to use, install the data scripter extension
2) Navigate to a table you want to script, right-click and select Script Table Data
3) You get a popup box as shown below
4) You can amend the TSQL statement above to just select columns you want or even add a WHERE clause. I have filtered the data for one specific date. Hit return
5) The scripter provides the create table statement commented out