title: Msg 2760, Level 16, State 1, Line 5 The specified schema name "items" either does not exist or you do not have permission to use it
body: <p>I am trying to create a temporal table in my SQL Server database. Is anyone familiar with this error in SQL Server: </p>
  
  <blockquote>
    <p>Msg 2760, Level 16, State 1, Line 5
    The specified schema name "items" either does not exist or you do not have permission to use it.</p>
  </blockquote>
  
  <p>I think there may be something wrong with my user privileges. Any help would be great.</p>
  
  <p>Here's the code:</p>
  
  <pre><code>CREATE TABLE [items].[items_Temporal](
      [itemsID] [int] NOT NULL, 
      [item_Name] [varchar](50) NOT NULL, 
      [item_Number] [int] NOT NULL, 
      [item_Price] [float] NOT NULL, 
      ValidFrom datetime2(7) GENERATED ALWAYS AS ROW START HIDDEN NOT NULL, 
      ValidTo datetime2(7) GENERATED ALWAYS AS ROW END HIDDEN NOT NULL,
  
      CONSTRAINT [PK_items_Temporal_items1ID] PRIMARY KEY CLUSTERED
      (
          [itemsID] ASC
      ), 
      PERIOD FOR SYSTEM_TIME(ValidFrom, ValidTo)
  )
  
  WITH(SYSTEM_VERSIONING = ON (HISTORY_TABLE = [items].[items_Temporal_History])); 
  </code></pre>