# Prisma 2.26.0 — Release & Upgrade Intelligence
- **Product:** Prisma (https://prisma.io)
- **Version:** 2.26.0
- **Released:** Jun 29, 2021
- **Impact Score:** 5/10
- **Breaking Changes:** Not verified
- **Canonical Analysis:** https://changelogs.us/prisma/updates/2.26.0/

## Executive Summary (TL;DR)
Prisma 2.26.0. Source highlight: Today, we are excited to share the `2.26.0` stable release 🎉

## New Features
- `sqlserver` (Preview, needs the `microsoftSqlServer` preview feature flag)
- Add TypeScript version check
- Failure creating a migration with MSSQL: `Introducing FOREIGN KEY constraint '...' on table '...' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.`
- Introspection migration adds ON UPDATE CASCADE ON DELETE SET NULL to foreign key constraints

## Improvements
- **Prisma Client no longer performs any checks before deleting records when invoking `delete()` or `deleteAll()` methods**. Deleting referenced objects will succeed or not depending on the underlying foreign keys of relations, e.g. by default deletion will be prevented by the database because it's set to `ON DELETE RESTRICT`, but will succeed if set to `ON DELETE CASCADE`.

## Upgrade Command
```bash
npm install --save-dev --save-exact prisma@2.26.0
```