title: SQL Multiple Foreign Keys as Primary Keys
body: <p>If I declare the table below does it implicitly imply that both the foreign keys make a unique primary key or do I need to do something more to make both attributes as a primary key?</p>
  
  <pre><code>CREATE TABLE Report_has_Items
  (
      ReportID int REFERENCES Report(ReportID) NOT NULL,
      ItemID int REFERENCES Item(ItemID) NOT NULL
  )
  </code></pre>
  
  <p>Essentially both attributes which are foreign keys from other tables, together would form a unique key.</p>