Is there a command to clear screen in SQLite3?

Question

To clear the SQLite console screen I tried cls, .cls, cls; and .cls; but no luck. Is there no cls command in SQLite?

Hendiadys

"cls" is a DOS command, not a sqlite command. – Instrumentality

Note quite - but this illudes the trick: ``` .print "\n\n\n\n\n\n\n\n\n\n\n\n" ``` – Sporogenesis

Answer 1

To execute CLS command in the SQLite3 shell you need to do this: .shell cls

As simple as that, .shell args... allows you to execute CMD commands in the SQLite3 shell.

Finnie

Note that .shell cls is for Windows, use .shell clear for Unix and Linux. – Fenestra

In git bash, it moves the cursor to top of screen but does not clear the console. – Loon

@Loon that is because git bash has the same behavior as a Linux terminal so clear doesn't really clear the console. Try using tput reset or just reset in your git bash to actually clear the console. – Modern

Answer 2

There is no clear command in the SQLite command-line client.

But, if you're on a unix-based system (includes Mac OS X) you can use: Ctrl+L

Update:
While my answer is quick and simple, if you're on a compatible OS, make sure you also check out ivan0590's answer about the .shell command. Definitely a "good to know" as well.

Deutschland

Here is a thread on askubuntu, explaining what Ctrl+l does, and why. – Jubilate

Answer 3

Depending on the shell. In Ubuntu -> .shell clear

Dara

Answer 4

On mac or Unix Operating systems:

   .shell clear

or:

   .shell reset

Poitiers

Answer 5

.shell cls will always work(C'mon, if you are in windows🙃). If you are using Linux/Unix/Mac OS, try using .shell clear

Arzola

Answer 6

For Windows:

.shell cls

For Linux and Mac:

.shell clear

Redeeming