Idea : Create Table Schema from Result Set

Skip to first unread message

Apr 26, 2019, 5:11:36 PM4/26/19
to DB Solo
Just an idea - 

If we could select the columns in a result set (and maybe the data to get the max width) and then right-click and select show CREATE TABLE script and then DBSOLO would create a script to create a table - even if things weren't perfect (i.e. how would it know the max width of a varchar column?) - it would still greatly improve the speed of creating a new table.

DB Solo Admin

Apr 27, 2019, 6:39:57 AM4/27/19
to DB Solo
You can use the 'Export result set' feature. Select 'SQL' as the output format and it gives you the option of having a CREATE TABLE statement at the beginning of the script. You can also pick which columns to include in the output.


May 6, 2019, 5:05:14 PM5/6/19
to DB Solo
THAT IS AWESOME!  I never noticed that before.    Absolutely wonderful!  
Reply all
Reply to author
0 new messages