If you've ever had to create a new tables from a set of results, you'll appreciate this feature. You can turn the results of your query into a whole new table. A CREATE TABLE statement will be generated that closely matches the layout of your results. In addition to this, INSERT statements will be generated for each row in your result set. All this generated SQL will be displayed in a new SQL Editor window. You can run it as is or modify it as you wish.
To use this feature, execute a query. Once the results are displayed, click on the Create Table From Results toolbar item.
The Werysoft Team
Cool stuff, thanks.
ReplyDelete