In the "Execute & Export to SQL" put the create table

[GoogleCodeExporter]

When I call "Execute & Export to SQL" option and open the result set file,
I think about "create table" into a file, because it's easier to apply a
script.

Original issue reported on code.google.com by daniel.h...@gmail.com on 11 Nov 2009 at 11:22

[GoogleCodeExporter]

My version is aseisql_trunk_205

Original comment by daniel.h...@gmail.com on 11 Nov 2009 at 11:23

[GoogleCodeExporter]

The resultset definition that is available when executing query is not enough to
build table correctly:
 - no user defined type info
 - not possible to separate char,varchar,nchar,..
 - no information about primary keys and other things...
But this is still possible to do with those limitations.

The limitation could be resolved with the following algorithm (we can do it 
later):
 - Catch all table names with limited DDLs,
 - After data export is over, try to populate DDLs from database for real table names

Finally
 - put all DDLs into one file

Original comment by daggett....@gmail.com on 11 Nov 2009 at 1:14

• Changed state: Feedback
• Added labels: Priority-Medium, Type-Enhancement