This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 255923 - Please add an option to show the created sql for a table
Summary: Please add an option to show the created sql for a table
Status: RESOLVED DUPLICATE of bug 154177
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 8.1
Hardware: PC Other
: P3 normal (vote)
Assignee: Libor Fischmeistr
Depends on:
Reported: 2015-10-14 12:49 UTC by Christian Lenz
Modified: 2017-01-08 11:24 UTC (History)
0 users

See Also:
Exception Reporter:


Note You need to log in before you can comment on or make changes to this bug.
Description Christian Lenz 2015-10-14 12:49:51 UTC
When I insert a new record to a table, I have the option "show SQL", above the visual stuff, I can see my sql "INSERT INTO....". This option is really needed for creating a table too. That I can copy it inside the visual stuff where I can create a new table. It should be also available for functions and views too.



P.S. Here you can see an example how 0xDBE does it from JetBrains:
Comment 1 Christian Lenz 2015-10-14 12:54:53 UTC
forget it for functions and view, because I think it doesn't make sense in this context. So only or tables.
Comment 2 Christian Lenz 2015-10-14 12:55:14 UTC
only FOR tables I mean.
Comment 3 Christian Lenz 2016-12-31 01:47:31 UTC
I'm working on a feature to show the SQL for a table when you right click on it and choose "View DDL/SQL". Then you got a little dialog, like the ShowSQLDialog where your Create Table SQL statement is inside. This is not sooo related to this bug but it helps to grab the structure without using "grab structure" save the file, and recreate a table to got the sql.
Comment 4 matthias42 2017-01-08 11:24:56 UTC

*** This bug has been marked as a duplicate of bug 154177 ***