title: SSDT Blow Up on Removing Temporal Tables
body: <p>Visual Studio 2019 - SSDT 16.0.</p>
  
  <p>I have 8 tables in a Dev database that were originally temporal. I removed the temporal portion of the table syntax and the project refused to build. I deleted the database and ran the project Transact for these tables in SSMS and all the Create Tables work. Deleted the database again and attempted to publish and the build failed. For each of the eight tables in the project that I converted to standard tables I receive an error message such as:</p>
  
  <blockquote>
    <p>incorrect syntax near ]</p>
  </blockquote>
  
  <p>on AircraftHistoryDetail.</p>
  
  <p>The double click modal on the error says:</p>
  
  <blockquote>
    <p>Cannot find file MSSQL:AircraftHistoryDetail.</p>
  </blockquote>
  
  <p>Here is the code on the AircraftDetails table:</p>
  
  <pre><code>CREATE TABLE [deploy].[AircraftDetail]
  (
      AircraftDetailId        INT IDENTITY(1,1),
      NameId                  INT,
      ProfileID               INT,
      ConstructionNumber      VARCHAR(50),
      ManufactureDate         VARCHAR(50),
      Model                   VARCHAR(50),
      Operator                VARCHAR(150),
      PreviousTailNumber      VARCHAR(50),
      ManufacturerSerialNumber VARCHAR(50),
      TailNumber              VARCHAR(50),
      [InactiveDate]          DATE   NULL,
      [CreatedFileDate] DATE         NULL,    
      CONSTRAINT PK_deploy_AircraftDetail PRIMARY KEY CLUSTERED ([AircraftDetailId] ASC),
      CONSTRAINT FK_deploy_AircraftDetail FOREIGN KEY (NameId)
          REFERENCES deploy.[Name] (NameId)
  );
  </code></pre>