View Issue Details

IDProjectCategoryView StatusLast Update
0000761Database Workbench v6Generalpublic2022-01-12 13:20
ReporterSvein Erling Tysvær Assigned ToMartijn Tonies  
Status acknowledgedResolutionopen 
Summary0000761: Add CREATE TABLE from query to SQL Editor
DescriptionSometimes I write queries that produce a result set that I want to store as a table in either the same or a different database. Currently, I then have to manually write the field name, type and length of every field. It would be great if it was possible to create (the skeleton of) a table based on the output of such a query, i.e. the same as 'Duplicate...' that you get when right-clicking on a table (except the source being a query rather than a table).
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2013-12-02 11:50 Svein Erling Tysvær New Issue
2013-12-02 12:57 Martijn Tonies Assigned To => Martijn Tonies
2013-12-02 12:57 Martijn Tonies Status new => acknowledged
2013-12-18 11:03 Martijn Tonies Project Database Workbench v4 => Database Workbench v5
2013-12-19 10:54 Martijn Tonies Category Firebird Module => General
2013-12-19 10:54 Martijn Tonies Summary Feature request - CREATE TABLE from query => Add CREATE TABLE from query to SQL Editor
2022-01-12 13:15 Martijn Tonies Project Database Workbench v5 => ADS LogManager
2022-01-12 13:15 Martijn Tonies Category General => @1@
2022-01-12 13:17 Martijn Tonies Project ADS LogManager => Database Workbench v6
2022-01-12 13:20 Martijn Tonies Category @1@ => General