oracle / quicksql

A library for generating DDL SQL and entity-relationship-diagrams from Quick SQL code
Universal Permissive License v1.0
52 stars 11 forks source link

The sequence deletion statement is not created if DROP='Y' #40

Closed alahe closed 7 months ago

alahe commented 9 months ago

Input

# pk: SEQ
# drop: Y
students 
    name

Output

drop table students cascade constraints;
-- create tables

create sequence  students_seq;

create table students (
    id      number default on null students_seq.nextval 
            constraint students_id_pk primary key,
    name    varchar2(255 char)
);

Expected output

drop table students cascade constraints;
drop sequence  students_seq;
-- create tables

create sequence  students_seq;

create table students (
    id      number default on null students_seq.nextval 
            constraint students_id_pk primary key,
    name    varchar2(255 char)
);
vadim-tropashko commented 7 months ago

1.2.1