Skip to content

Delete all rows on the table that are older than 100 days

USE Database_name;
DELETE FROM Table_name
WHERE Date_column < GETDATE() - 100
Published inWindows