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?

"cls" is a DOS command, not a sqlite command. – user2864740 Feb 06 '14 at 23:37 — user2864740, Feb 06 '14 at 23:37

score 83 · Accepted Answer · answered Aug 09 '14 at 11:12

83

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.

answered Aug 09 '14 at 11:12

ivan0590

1,229
11
18

33

Note that `.shell cls` is for Windows, use `.shell clear` for Unix and Linux. – Stian OK Aug 05 '15 at 22:35
In git bash, it moves the cursor to top of screen but does not clear the console. – mallaudin Oct 19 '16 at 07:44
1

@mallaudin 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. – Sumit Sep 06 '17 at 20:00

score 31 · Answer 2 · edited Dec 19 '17 at 13:01

31

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.

edited Dec 19 '17 at 13:01

answered Feb 06 '14 at 23:36

Timeout

7,759
26
38

1

Here is a [thread on askubuntu](https://askubuntu.com/questions/434240/ctrll-in-terminal), explaining what `Ctrl+l` does, and why. – Dec 19 '17 at 06:41

score 7 · Answer 3 · answered May 29 '17 at 09:13

7

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

answered May 29 '17 at 09:13

OZ13

256
3
4

joan · Answer 4 · 2023-07-08T14:46:37.090

6

On mac or Unix Operating systems:

   .shell clear

or:

   .shell reset

edited Jul 08 '23 at 14:46

answered Oct 09 '17 at 10:14

joan

2,407
4
29
35

score 5 · Answer 5 · answered Aug 21 '21 at 17:43

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

answered Aug 21 '21 at 17:43

Arjun Praveen

119
2
2

score 4 · Answer 6 · answered May 16 '22 at 14:16

4

For Windows:

.shell cls

For Linux and Mac:

.shell clear

answered May 16 '22 at 14:16

Super Kai - Kazuya Ito

22,221
10
124
129

Is there a command to clear screen in SQLite3?

6 Answers6