title: Get "Foreign key references invalid table" error when the table exists
body: <p>I have three tables</p>
  
  <pre><code>Create table PROPERTY(
      property_number     int,
      property_name       int,
      property_type       varchar(30),
      property_street     varchar(30),
      property_city       varchar(30),
      property_zip        int,
      constraint PK_PROPRETY_NUMBER primary key(property_number)
  )
  
  Create table SERVICE(
      service_ID              int,
      service_description     varchar(150),
      service_amount          money,
      constraint PK_SERVICE_ID primary key(service_ID),
  )
  
  Create table SERVICEHISTORY(
      service_ID          int,
      service_date        date,
      property_number     int,
      constraint PK_SERVICEHISTORY_ID primary key(service_ID, service_date),
      constraint FK_SERVICE_ID foreign key(service_ID)
              references SERVICE(service_ID),
      constraint FK_PROPERTY_NUMBER foreign key(property_number)
              references PROPERTY(property_number)
  )
  </code></pre>
  
  <p>I run the first two successfully, and they appear in the Object Explorer under "Tables".  In SERVICEHISTORY, the "references SERVICE", and, "PROPERTY" are erred.  When I run that script, I get:</p>
  
  <pre><code>Msg 1767, Level 16, State 0, Line 11
  Foreign key 'FK_SERVICE_ID' references invalid table 'SERVICE'.
  Msg 1750, Level 16, State 0, Line 11
  Could not create constraint. See previous errors.
  </code></pre>
  
  <p>What's going on here?</p>