Mit dem CHECK-Constraint können wir den Wertebereich limitieren.
CREATE TABLE Persons ( Id INTEGER NOT NULL, LastName VARCHAR(255) NOT NULL, FirstName VARCHAR(255), Age INTEGER, City VARCHAR(255), CONSTRAINT CK_Person_Age CHECK (Age >= 18));
ALTER TABLE PersonsADD CONSTRAINT CK_Person_Age CHECK (Age >= 18);
ALTER TABLE PersonsDROP CHECK CK_Person_Age;
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Lerndokumentation","colors":{"primary":"#009689","light":"#00BBA7","dark":"#009689"},"favicon":{"light":"https://mintcdn.com/levexis-38849a2b/Dl8Ug2Oz__n4NGvK/images/favicon.svg?fit=max\u0026auto=format\u0026n=Dl8Ug2Oz__n4NGvK\u0026q=85\u0026s=3dbec411ba81d95eecad2211eba220aa","dark":"https://mintcdn.com/levexis-38849a2b/Dl8Ug2Oz__n4NGvK/images/favicon.svg?fit=max\u0026auto=format\u0026n=Dl8Ug2Oz__n4NGvK\u0026q=85\u0026s=3dbec411ba81d95eecad2211eba220aa"},"background":{"decoration":"gradient"},"navbar":{"links":[]},"footer":{"socials":{"x":"https://x.com/levinbaenninger","github":"https://github.com/levinbaenninger","linkedin":"https://linkedin.com/levinbaenninger","website":"https://levin.baenninger.me"}},"icons":{"library":"fontawesome"},"styling":{"latex":true},"contextual":{"options":["copy","view","chatgpt","claude","perplexity","mcp","cursor","vscode"],"display":"header"},"navigation":{"directory":"card","pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"levexis-38849a2b","hasAudioNarration":false,"actualSubdomain":"levexis-38849a2b","customDomains":["docs.baenninger.me"],"gitSource":{"type":"github","owner":"levinbaenninger","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":false,"mountPath":"","label":""},"chroma":{"collectionId":"48bfa8fc-eb4e-4ac7-888e-2bd5f745ba78","liveDeploymentHistoryId":"6a32df1043f65b528263cee6","schemaVersion":"v3"},"entitlements":{"AI_CHAT":{"status":"DISABLED"}},"buildId":"6a32df1043f65b528263cee6:success","clientVersion":"0.0.3883","searchFilterCounts":[{"language":"default","tag":"Web","count":124},{"language":"default","tag":".NET","count":49},{"language":"default","tag":"JavaScript","count":47},{"language":"default","tag":"Datenbanken","count":39},{"language":"default","tag":"C\\#","count":32},{"language":"default","tag":"Security","count":28},{"language":"default","tag":"SQL","count":25},{"language":"default","tag":"TypeScript","count":25},{"language":"default","tag":"Prozesse","count":21},{"language":"default","tag":"React","count":17}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":true,"enableContextualStarterQuestions":true,"enableAskAiSearchBar":true,"deflection":{"enabled":true,"email":"levin@baenninger.me","showHelpButton":true}},"hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-v7-file-tree","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"pause-universal-search-reconcile","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"per-site-search-delta","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-branches-v2-autocommit","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-branches-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-private-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"teamspace","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-nav-generations","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"byok-sep-25","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-agent-model-picker","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"client-snapshot-docs-config","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"isAtlas":false,"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"databases/sql/struktur/datenbanken-und-tabellen/constraints/check","slug":"/databases/sql/struktur/datenbanken-und-tabellen/constraints/check","pageMetadata":{"title":"CHECK","icon":"check","description":null,"href":"/databases/sql/struktur/datenbanken-und-tabellen/constraints/check"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,p:`p`,pre:`pre`,span:`span`,..._provideComponents(),...props.components},{CodeBlock}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[`Mit dem `,_jsx(_components.code,{children:`CHECK`}),`-Constraint können wir den Wertebereich limitieren.`]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`8`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`8`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`CREATE`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` TABLE`}),_jsx(_components.span,{style:{color:`#8250DF`,\"--shiki-dark\":`#DCDCAA`},children:` Persons`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` Id `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`INTEGER`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` NOT NULL`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` LastName `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`VARCHAR`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`255`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`NOT NULL`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` FirstName `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`VARCHAR`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`255`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`),`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` Age `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`INTEGER`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` City `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`VARCHAR`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`255`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`),`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` CONSTRAINT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` CK_Person_Age `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`CHECK`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (Age `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`>=`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 18`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`)`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`);`})}),`\n`]})})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`2`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`2`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ALTER`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` TABLE`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` Persons`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ADD`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` CONSTRAINT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` CK_Person_Age `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`CHECK`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (Age `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`>=`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 18`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`);`})]}),`\n`]})})}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`2`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`2`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ALTER`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` TABLE`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` Persons`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`DROP`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` CHECK`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` CK_Person_Age;`})]}),`\n`]})})})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"CHECK","icon":"check","description":null,"href":"/databases/sql/struktur/datenbanken-und-tabellen/constraints/check"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"subdomain":"levexis-38849a2b","siteName":"Lerndokumentation","title":"CHECK - Lerndokumentation","contextualStarterQuestions":[{"_id":"6a32df3c689789964bfcf64f","deploymentId":"6a282b36869562311e8a609d","questionText":"What is a CHECK constraint?","status":"active","generatedBy":"contextual","path":"databases/sql/struktur/datenbanken-und-tabellen/constraints/check","createdAt":"2026-06-17T17:54:04.428Z","updatedAt":"2026-06-17T17:54:04.428Z","__v":0},{"_id":"6a32df3c689789964bfcf64e","deploymentId":"6a282b36869562311e8a609d","questionText":"How do I limit value ranges?","status":"active","generatedBy":"contextual","path":"databases/sql/struktur/datenbanken-und-tabellen/constraints/check","createdAt":"2026-06-17T17:54:04.428Z","updatedAt":"2026-06-17T17:54:04.428Z","__v":0},{"_id":"6a32df3c689789964bfcf650","deploymentId":"6a282b36869562311e8a609d","questionText":"How do I remove a CHECK?","status":"active","generatedBy":"contextual","path":"databases/sql/struktur/datenbanken-und-tabellen/constraints/check","createdAt":"2026-06-17T17:54:04.428Z","updatedAt":"2026-06-17T17:54:04.428Z","__v":0}],"navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-06-17T17:53:42.261Z","originalFileLocation":"databases/sql/struktur/datenbanken-und-tabellen/constraints/check.mdx"},"headHtml":"\u003cmeta data-mint-head name=\"application-name\" content=\"Lerndokumentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/levexis-38849a2b/1O9KTqd-AXqEw_yT/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/levexis-38849a2b/1O9KTqd-AXqEw_yT/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/levexis-38849a2b/1O9KTqd-AXqEw_yT/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/levexis-38849a2b/1O9KTqd-AXqEw_yT/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/levexis-38849a2b/1O9KTqd-AXqEw_yT/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/levexis-38849a2b/1O9KTqd-AXqEw_yT/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/levexis-38849a2b/1O9KTqd-AXqEw_yT/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/levexis-38849a2b/1O9KTqd-AXqEw_yT/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/levexis-38849a2b/1O9KTqd-AXqEw_yT/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"CHECK - Lerndokumentation\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Lerndokumentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/constraints/check\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"CHECK - Lerndokumentation\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/levexis-38849a2b/1O9KTqd-AXqEw_yT/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Lerndokumentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#009689\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/constraints/check\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/databases/sql/struktur/datenbanken-und-tabellen/constraints/check.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.baenninger.me/#organization\",\"name\":\"Lerndokumentation\",\"url\":\"https://docs.baenninger.me\"},{\"@type\":\"WebSite\",\"@id\":\"https://docs.baenninger.me#website\",\"name\":\"Lerndokumentation\",\"url\":\"https://docs.baenninger.me\",\"publisher\":{\"@id\":\"https://docs.baenninger.me/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/constraints/check#webpage\",\"url\":\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/constraints/check\",\"name\":\"CHECK\",\"dateModified\":\"2026-06-17T17:53:42.261Z\",\"isPartOf\":{\"@id\":\"https://docs.baenninger.me#website\"},\"breadcrumb\":{\"@id\":\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/constraints/check#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/constraints/check#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"SQL\",\"item\":\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/datentypen\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Struktur\",\"item\":\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/datentypen\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Datenbanken und Tabellen\",\"item\":\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/datentypen\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Constraints\",\"item\":\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/constraints/not-null\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"CHECK\",\"item\":\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/constraints/check\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/constraints/check#article\",\"headline\":\"CHECK\",\"name\":\"CHECK\",\"url\":\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/constraints/check\",\"mainEntityOfPage\":{\"@id\":\"https://docs.baenninger.me/databases/sql/struktur/datenbanken-und-tabellen/constraints/check#webpage\"},\"dateModified\":\"2026-06-17T17:53:42.261Z\",\"publisher\":{\"@id\":\"https://docs.baenninger.me/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.baenninger.me#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Lerndokumentation\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Lerndokumentation","nav":{"global":null,"directory":"card","tabs":[{"tab":"Start","icon":"house","pages":[{"title":"Start","href":""}]},{"tab":"Web","icon":"globe","pages":[{"title":"Web","href":"/web/html/was-ist-html"}]},{"tab":".NET","icon":"microsoft","pages":[{"title":".NET","href":"/dotnet/c/variablen/strings"}]},{"tab":"C","icon":"cuttlefish","pages":[{"title":"C","href":"/c/input-und-output"}]},{"tab":"Cloud","icon":"cloud","pages":[{"title":"Cloud","href":"/cloud/grundlagen/cloud-computing"}]},{"tab":"Datenbanken","icon":"database","pages":[{"title":"SQL vs. NoSQL","icon":"scale-balanced","href":"/databases/grundlagen/sql-vs.-nosql"},{"title":"NoSQL-Familien","icon":"sitemap","href":"/databases/grundlagen/nosql-familien"},{"title":"CAP-Theorem","icon":"triangle-exclamation","href":"/databases/grundlagen/cap-theorem"},{"title":"Vorgehen beim Erstellen","icon":"list-check","href":"/databases/grundlagen/vorgehen-beim-erstellen"},{"title":"ACID - BASE","icon":"flask","href":"/databases/grundlagen/acid-base"},{"title":"Indizes","icon":"magnifying-glass-chart","href":"/databases/grundlagen/indizes"},{"group":"SQL","icon":"database","pages":[{"group":"Struktur","icon":"sitemap","pages":[{"group":"Datenbanken und Tabellen","icon":"table","pages":[{"title":"Datentypen","icon":"table-cells","href":"/databases/sql/struktur/datenbanken-und-tabellen/datentypen"},{"title":"Erstellen","icon":"square-plus","href":"/databases/sql/struktur/datenbanken-und-tabellen/erstellen"},{"title":"Bearbeiten","icon":"pen-to-square","href":"/databases/sql/struktur/datenbanken-und-tabellen/bearbeiten"},{"title":"Löschen","icon":"trash","href":"/databases/sql/struktur/datenbanken-und-tabellen/loschen"},{"group":"Constraints","icon":"lock","pages":[{"title":"NOT NULL","icon":"ban","href":"/databases/sql/struktur/datenbanken-und-tabellen/constraints/not-null"},{"title":"UNIQUE","icon":"fingerprint","href":"/databases/sql/struktur/datenbanken-und-tabellen/constraints/unique"},{"title":"Primärschlüssel","icon":"key","href":"/databases/sql/struktur/datenbanken-und-tabellen/constraints/primarschlussel"},{"title":"Fremdschlüssel","icon":"link","description":null,"href":"/databases/sql/struktur/datenbanken-und-tabellen/constraints/fremdschlussel"},{"title":"CHECK","icon":"check","href":"/databases/sql/struktur/datenbanken-und-tabellen/constraints/check"},{"title":"DEFAULT","icon":"gear","description":null,"href":"/databases/sql/struktur/datenbanken-und-tabellen/constraints/default"}]}]},{"group":"Daten","icon":"grip","pages":[{"title":"Einfügen","icon":"plus","href":"/databases/sql/struktur/daten/einfugen"},{"title":"Aktualisieren","icon":"arrows-rotate","href":"/databases/sql/struktur/daten/aktualisieren"},{"title":"Löschen","icon":"trash","href":"/databases/sql/struktur/daten/loschen"}]}]},{"group":"Abfragen","icon":"magnifying-glass","pages":[{"title":"Auswählen","icon":"arrow-pointer","href":"/databases/sql/abfragen/auswahlen"},{"title":"Filtern","icon":"filter","href":"/databases/sql/abfragen/filtern"},{"title":"Operatoren","icon":"filter-circle-dollar","href":"/databases/sql/abfragen/operatoren"},{"title":"Reihenfolge","icon":"arrow-down-wide-short","href":"/databases/sql/abfragen/reihenfolge"},{"title":"JOINS","icon":"link","href":"/databases/sql/abfragen/joins"},{"group":"Aggregatsfunktionen","icon":"calculator","root":{"title":"Aggregatsfunktionen","icon":"chart-simple","href":"/databases/sql/abfragen/aggregatsfunktionen/README"},"pages":[{"title":"Gruppieren","icon":"object-group","href":"/databases/sql/abfragen/aggregatsfunktionen/gruppieren"},{"title":"Filtern","icon":"filter-circle-dollar","href":"/databases/sql/abfragen/aggregatsfunktionen/filtern"}]},{"title":"Subqueries","icon":"magnifying-glass-plus","href":"/databases/sql/abfragen/subqueries"}]},{"title":"Transaktionen","icon":"right-left","href":"/databases/sql/transaktionen"},{"group":"Datenschutz und Berechtigungen","icon":"shield-halved","root":{"title":"Datenschutz und Berechtigungen","icon":"shield-halved","href":"/databases/sql/datenschutz-und-berechtigungen/README"},"pages":[{"title":"Benutzerverwaltung","icon":"user-gear","href":"/databases/sql/datenschutz-und-berechtigungen/benutzerverwaltung"},{"title":"Rechte","icon":"key","href":"/databases/sql/datenschutz-und-berechtigungen/rechte"}]},{"title":"Optimierung","icon":"gauge-high","href":"/databases/sql/optimierung"}]},{"group":"MongoDB","icon":"envira","pages":[{"title":"Was ist MongoDB?","icon":"envira","iconType":"brands","href":"/databases/mongodb/was-ist-mongodb"},{"group":"Struktur","icon":"sitemap","pages":[{"title":"Datenbanken und Collections","icon":"boxes-stacked","href":"/databases/mongodb/struktur/datenbanken-und-collections"},{"title":"Daten","icon":"leaf","href":"/databases/mongodb/struktur/daten"}]},{"title":"Abfragen","icon":"magnifying-glass","href":"/databases/mongodb/abfragen"},{"title":"Indexing","icon":"magnifying-glass-chart","href":"/databases/mongodb/indexing"},{"group":"Security","icon":"shield-halved","pages":[{"title":"Authentifizierung und Autorisierung","icon":"user-lock","href":"/databases/mongodb/security/authentifizierung-und-autorisierung"},{"title":"Auditing","icon":"clipboard-check","href":"/databases/mongodb/security/auditing"}]},{"title":"Backups","icon":"box-archive","href":"/databases/mongodb/backups"}]}]},{"tab":"Containerisierung","icon":"box","pages":[{"title":"Containerisierung","href":"/container/grundlagen/containerisierung"}]},{"tab":"Testing","icon":"vial-virus","pages":[{"title":"Testing","href":"/testing/grundlagen/begriffe"}]},{"tab":"Security","icon":"shield-halved","pages":[{"title":"Security","href":"/security/grundlagen/informationssicherheit"}]},{"tab":"Prozesse","icon":"diagram-project","pages":[{"title":"Prozesse","href":"/processes/agile-entwicklung/was-ist-agile-enwicklung"}]},{"tab":"Diverses","icon":"wand-magic-sparkles","pages":[{"title":"Diverses","href":"/miscellaneous/kunstliche-intelligenz/grundlagen"}]}]},"title":"CHECK - Lerndokumentation","buildId":"dpl_37ZDLJcyt8yhrTVF6LiYvX7LvmXB","deploymentId":"dpl_37ZDLJcyt8yhrTVF6LiYvX7LvmXB","dynamics":[],"chunks":[]}