Bug 155358 - Export schema to SQL DDL
Export schema to SQL DDL
Status: NEW
Product: db
Classification: Unclassified
Component: Code
All All
: P2 with 1 vote (vote)
Assigned To: Libor Fischmeistr
Depends on:
  Show dependency treegraph
Reported: 2008-12-12 14:52 UTC by Roman Mostyka
Modified: 2016-12-07 14:24 UTC (History)
2 users (show)

See Also:


Note You need to log in before you can comment on or make changes to this bug.
Description Roman Mostyka 2008-12-12 14:52:57 UTC
Export schema to SQL DDL.
Comment 1 Jiri Rechtacek 2009-10-16 14:10:04 UTC
Reassigned to new owner.
Comment 2 paolosca 2010-04-22 11:03:40 UTC
This is this more or less provided by "Show SQL script for CREATE" and "Show SQL script for INSERT" but it would be very comfortable to be able to do it directly from the database tree for selected tables or the whole database.
Comment 3 gery51 2012-11-28 23:42:00 UTC
An Import schema from sql would be very nice too !
Comment 4 ChrisLE 2016-12-07 14:24:05 UTC
I changed the version to 8.2 because this is still a problem and not implemented yet. I know the context menu "grab structure" but there are to many steps. Right click on table -> grab structure -> choose a folder where you want to save the table_name.grab file -> e.g. delete the table -> right click on Tables -> Recreate table -> use the grab file and you can edit the SQL DDL. Toooo many steps.


Right click on table -> grab DDL structure to clipboard (Or whatever) -> you have the SQL DDL statement for creating table in the clipboard. DataGrip, the DB IDE from JetBrains did this and it is very handy.



By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2014, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo