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

sqlite_sequence showing up in the tree #152

Closed
julientype opened this issue Mar 27, 2019 · 3 comments

Comments

2 participants
@julientype
Copy link

commented Mar 27, 2019

in sqlite when you create an auto increment index value it creates a table called
sqlite_sequence

this is basically a trigger type operation not an input table operation

to logically group this table type entry it should show up as a trigger entry its not a regular table.

SQLite - Triggers. SQLite trigger may be specified to fire whenever a DELETE, INSERT or UPDATE of a particular database table occurs or whenever an UPDATE occurs on one or more specified columns of a table. At this time, SQLite supports only FOR EACH ROeW triggers, not FOR EACH STATEMENT triggers.

I believe it should show up as a trigger table..... its like it a table holding values yet its not a regular table and its not trigger statement because its a table yet it it functions the same...

?????? 2+ icons needed for trigger type statements and icons help in identifying data objects to move around in code yet seen at a visual level before coding...... styles implement code not code implementing styles later

@julientype julientype added the bug label Mar 27, 2019

@project-bot project-bot bot added this to To do in Kanban Mar 27, 2019

@mtxr

This comment has been minimized.

Copy link
Owner

commented May 23, 2019

@julientype do you want to work on this issue?

@mtxr

This comment has been minimized.

Copy link
Owner

commented May 23, 2019

Actually, I'll remove that table from tree.

All other tools doesn't show it. So I won't show it too.

@mtxr mtxr changed the title sqlite_sequence sqlite_sequence showing up in the tree May 23, 2019

@mtxr mtxr self-assigned this May 23, 2019

@project-bot project-bot bot moved this from To do to In progress in Kanban May 23, 2019

@mtxr mtxr closed this in f2cc875 May 23, 2019

Kanban automation moved this from In progress to To be released May 23, 2019

@julientype

This comment has been minimized.

Copy link
Author

commented May 23, 2019

sqlite_sequence just needs to be hidden when you load your tables .... its relay an internal table you should not edit..... in fact sqlight will prevent any operation to it even delete....

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.