SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Table1 (
  ID INT NOT NULL PRIMARY KEY
  , ValidFrom DATETIME2 GENERATED ALWAYS AS ROW START HIDDEN NOT NULL
  , ValidTo DATETIME2 GENERATED ALWAYS AS ROW END HIDDEN NOT NULL
  , PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo)
)
WITH (SYSTEM_VERSIONING = ON)
CREATE TABLE Table2 (
  ID INT NOT NULL PRIMARY KEY
)
DECLARE @cols nvarchar(max) = (
    SELECT STRING_AGG('t.' + QUOTENAME(c1.name), ', ')
    FROM sys.tables t1
    JOIN sys.columns c1 ON t1.object_id = c1.object_id
    JOIN sys.tables t2
      ON t2.name = 'Table2'
    JOIN sys.columns c2 ON t2.object_id = c2.object_id
      AND c2.name = c1.name
    WHERE t1.name = 'Table1'
      AND c1.is_hidden = 0
      AND c2.is_hidden = 0
);

DECLARE @sql nvarchar(max) = '
DELETE t
FROM Table1 t
WHERE NOT EXISTS (
    SELECT ' + @cols + '
    EXCEPT
    SELECT ' + @cols + '
    FROM Table2 t
);
';

PRINT @sql;  -- your friend

EXEC sp_executesql @sql;

DELETE t
FROM Table1 t
WHERE NOT EXISTS (
    SELECT t.[ID]
    EXCEPT
    SELECT t.[ID]
    FROM Table2 t
);



DELETE FROM [Table1]
  WHERE [Table1].[ID] NOT IN (
    SELECT ID FROM (
      SELECT * FROM [Table1]
      EXCEPT
      SELECT * FROM [Table2]
    ) AS INNER_QUERY
  )
Msg 205 Level 16 State 1 Line 1
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

DELETE FROM [Table1]
  WHERE NOT EXISTS (SELECT 1
     FROM  (
      SELECT Table1.*
      EXCEPT
      SELECT * FROM [Table2]
    ) AS INNER_QUERY
  )
Msg 205 Level 16 State 1 Line 1
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

DELETE FROM [Table1]
  WHERE NOT EXISTS (SELECT 1
     FROM  (
      SELECT * FROM [Table1] t1
      WHERE t1.ID = Table1.ID
      EXCEPT
      SELECT * FROM [Table2]
    ) AS INNER_QUERY
  )
Msg 205 Level 16 State 1 Line 1
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

DELETE FROM INNER_QUERY
     FROM  (
      SELECT Table1.* FROM [Table1]
      EXCEPT
      SELECT * FROM [Table2]
    ) AS INNER_QUERY
Msg 205 Level 16 State 1 Line 1
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

SELECT * FROM [Table1]
  WHERE [Table1].[ID] NOT IN (
    SELECT ID FROM (
      SELECT * FROM [Table1]
      EXCEPT
      SELECT * FROM [Table2]
    ) AS INNER_QUERY
  )


ID