[DERBY-64] Create a table with a query

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 10.3.1.4
• Component/s: SQL
• Assignee: James F. Adams
• Reporter: Christian d'Heureuse
• Created: 10/Nov/04 21:30
• Updated: 21/Jan/11 17:48
• Resolved: 02/Feb/07 21:57

Description

I suggest to implement a SQL statement to create and fill a table with a query, without having to write the columns definition.

e.g.:

CREATE TABLE new_table AS SELECT ...;

or:

SELECT ... INTO new_table FROM ...;

Issue Links

• is related to: DERBY-2605 You can create BOOLEAN columns in 10.3
• relates to: DERBY-2288 Support WITH DATA option of CREATE TABLE new_table AS subquery WITH [NO] DATA
• relates to: DERBY-2593 Add documentation for the CREATE TABLE as subquery clause