title: Column vs Table Primary Key constraint in a SQLite table
body: <p>I'm medling with SQLite databases, and from the <a href="http://www.sqlite.org/lang_createtable.html" rel="nofollow">documentation</a> : </p>
  
  <blockquote>
    <p>Each table in SQLite may have at most one PRIMARY KEY. If the keywords
    PRIMARY KEY are added to a column definition, then the primary key for
    the table consists of that single column. Or, if a PRIMARY KEY clause
    is specified as a table-constraint, then the primary key of the table
    consists of the list of columns specified as part of the PRIMARY KEY
    clause.</p>
  </blockquote>
  
  <p>My question is when there's a single column to be used as a <code>PRIMARY KEY</code>, is there a fundamental difference between the two following commands ? </p>
  
  <pre><code>CREATE TABLE t (x INTEGER, y TEXT ,  PRIMARY KEY (x));
  
  CREATE TABLE t (x INTEGER PRIMARY KEY, y TEXT);
  </code></pre>