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.
I created a table like this: ---- SQL Code ---- CREATE TABLE PEOPLE (PERSON_ID INT NOT NULL GENERATED ALWAYS AS IDENTITY CONSTRAINT PEOPLE_PK PRIMARY KEY, PERSON VARCHAR(26)) ---- End ---- and then I "grab structure" it, it's ok, but when I try to recreate it with the grab file, things goes wrong. the script generated looks like that, and can't be executed: ---- Script generate by Netbeans --- create table "HIARCS".PEOPLE ( PERSON_ID INTEGER default AUTOINCREMENT: start 1 increment 1 not null primary key, PERSON VARCHAR(26) ) ---- End ---- I know it's difficult to deal with different SQL db, so I don't expect we can grab and recreate anything anytime. But the point is, I don't received any msg or warning during the grab operation, so I may delete the sql command and think "with this grab file everything is ok", it could make me miserable later. On the other hand, I can open a sql file with Netbeans but can't find an easy way to save the command into .sql file (maybe I missed), so in my opinion it will be better if we: 1. raise a waring when people grab 2. allow people save command as sql file 3. when people recreate table with grab file, Edit table script, run it and success, update the grab file if possible.
Reassigned to new owner.