quicksql
quicksql copied to clipboard
Commented QuickSQL in Generated SQL Script Can't Be Pasted As Is into QuickSQL Again
When you create a table with QuickSQL, the generated SQL script contains a commented version of the QuickSQL source like:
/*
person
name
Non-default options:
# settings = {"apex":"Y","db":"19c","pk":"IDENTITY"}
*/
Later, when you want to modify the schema, you typically start by pasting the QuickSQL source in the comment back into the QuickSQL editor as the baseline. However, the presence of the "Non-default options:" causes problems since QuickSQL treats that as a column name if pasted in verbatim. This line should be generated in a way that QuickSQL will ignore if pasted in verbatim.
-- create tables
create table person (
id number generated by default on null as identity
constraint person_id_pk primary key,
name varchar2(255 char),
"Non-default options:" varchar2(4000 char)
);