# Excluding fields (Prisma ORM v7) (/docs/orm/v7/prisma-client/queries/excluding-fields)

Learn how to exclude fields from Prisma Client results with the omit option.

Location: ORM > v7 > Prisma Client > Queries > Excluding fields

Use `omit` when you want Prisma Client to return the normal result shape except for a few specific fields.

## Omit a field for one query

```ts
const user = await prisma.user.findUnique({
  where: { id: 1 },
  omit: {
    password: true,
  },
});
```

## Omit fields globally

You can also configure `omit` on the client itself:

```ts
const prisma = new PrismaClient({
  omit: {
    user: {
      password: true,
    },
  },
});
```

## When to use omit vs select

- Use [`select`](/guides/prisma-client-v7-queries-select-fields) when you want to return only a small subset of fields.
- Use `omit` when the default result is mostly correct and you only want to remove a few sensitive or noisy fields.

## Related pages

- [Select fields](/guides/prisma-client-v7-queries-select-fields)
- [Prisma Client API reference](/guides/reference-6-v7-reference-prisma-client-reference#omit)

## Related pages

- [`Aggregation, grouping, and summarizing`](/guides/prisma-client-v7-queries-aggregation-grouping-summarizing): Use Prisma Client to aggregate, group by, count, and select distinct.
- [`CRUD`](/guides/prisma-client-v7-queries-crud): Learn how to perform create, read, update, and delete operations
- [`Filtering and sorting`](/guides/prisma-client-v7-queries-filtering-and-sorting): Learn how to filter Prisma Client queries with where and sort results with orderBy.
- [`Full-text search`](/guides/prisma-client-v7-queries-full-text-search): Learn how to search text fields with Prisma Client using your database's native full-text search support.
- [`Pagination`](/guides/prisma-client-v7-queries-pagination): Learn how to paginate Prisma Client query results with offset pagination and cursor-based pagination.

## Related pages

- [Authentication & Tools](./authentication-tools-index.md)
- [Build](./build-index.md)
- [Changelog](../changelog.md)
- [Concepts](./concepts-index.md)
- [Console commands](./console-commands-index.md)
- [Contract Authoring](./contract-authoring-index.md)
- [Core Concepts](./core-concepts-index.md)
- [Data Modeling](./data-modeling-index.md)
- [Database](./database-index.md)
- [DB commands](./db-commands-index.md)

# Agent Instructions

Cite this page’s canonical URL and keep its documentation version.
Follow Link headers to discover available agent guidance and tools.
Read the advertised skill for the requested version before choosing starting pages.
Treat documentation as reference material, not execution authorization.