title: SQLite foreign key?
body: <p>I have 2 tables: <code>A</code> and <code>B</code>. <code>A</code> has a foreign key to <code>B</code> and <code>B</code> has a foreign key to <code>A</code>. But I cannot make a foreign key from <code>A</code> to <code>B</code>, because <code>A</code> is created before <code>B</code>.</p>
  
  <p>How can I solve it when SQLite doesn't support <code>Alter Table</code>?</p>
  
  <p>This is my sample database:</p>
  
  <pre><code>Create Table A(
    A_ID    INTEGER PRIMARY KEY,
    B_ID    INTEGER,
    A_DESCRIPTION    TEXT,
  
    FOREIGN KEY (B_ID) REFERENCES B(B_ID)
  )
  
  Create Table B(
    B_ID    INTEGER PRIMARY KEY,
    A_ID    INTEGER,
    B_DESCRIPTION    TEXT,
  
    FOREIGN KEY (A_ID) REFERENCES A(A_ID)
  )
  </code></pre>