We by default don’t store certain things in your SQLcl HISTORY list – like CONNECTs. For obvious reasons, it’s best not to store certain things, either for convenience or for security.
Here’s how that is controlled.
SET HISTORY BLACKLIST command1, command2, …, commandN
So I previously added ALTER to the list, and just now added DESC. And then I ran a few commands that use those blacklisted commands.
Now let’s check our HISTORY.
Note: we changed how the blacklisting is managed from when the Early Adopter was running.
Where is this file stored?
Same place we store your ALIAS list of commands…it’s per OS user, not per install of SQLcl.