SQL Server: Cascade Delete

To delete a record, with all of its reference records, in other tables is not an easy task, especially when database has dozens of tables. Cascade delete in SQL Server is only possible by writing your own script and there is no built in keyword or function which can help you for this task.