Unless the NONTEMPORAL qualifier is specified, deletion on temporal tables with a transaction-time column is always limited to only those rows that are open in transaction time.
Unless the NONTEMPORAL qualifier is specified, deletion on temporal tables with a transaction-time column is always limited to only those rows that are open in transaction time.