title: How to vacuum sqlite database?
body: <p>I want to know how to vacuum sqlite database.
  I tried  a syntax MANUAL VACUUM command for the whole database from command prompt:</p>
  
  <pre><code> $sqlite3 database_name "VACUUM;";
  </code></pre>
  
  <p>But it's giving error as:</p>
  
  <pre><code>near "database_name": syntax error.
  </code></pre>
  
  <p>and also AUTO VACUUM:</p>
  
  <pre><code>PRAGMA auto_vacuum = INCREMENTAL;
  </code></pre>
  
  <p>And tried it for a particular table as:</p>
  
  <pre><code>VACUUM table_name;
  </code></pre>
  
  <p>But no result.</p>