Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
alahe opened this issue Dec 18, 2023 · 1 comment
Closed

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

alahe opened this issue Dec 18, 2023 · 1 comment
Assignees

Comments

@alahe
Copy link

alahe commented Dec 18, 2023

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 vadim-tropashko self-assigned this Jan 20, 2024
@vadim-tropashko
Copy link
Member

1.2.1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants